This page presents how to work with Microsoft Excel 2007 features and its redesigned interface. You may also visit our Excel Question page.

Type of Formula

Example

Conditional

Create conditional formulas

Check if a number is greater than or less than another number

Display or hide zero values

Hide error values and error indicators in cells

Lookup

Look up values in a list of data

Date and Time

Add dates

Add times

Calculate the difference between two dates

Calculate the difference between two times

Count days before a date

Show dates as days of the week

Insert the current date and time in a cell

Insert Julian dates

Financial

Calculate a running balance

Calculate a compound annual growth rate (CAGR)

Statistical

Calculate the average of a group of numbers

Calculate the median of a group of numbers

Calculate the mode of a group of numbers

Math

Add numbers

Subtract numbers

Multiply numbers

Divide numbers

Calculate percentages

Round a number

Raise a number to a power

Calculate the smallest or largest number in a range

Calculate the factorial or permutation of a number

Create a multiplication table

Counting

Count cells that contain numbers

Count nonblank cells

Count how often a value occurs

Count unique values among duplicates

Count numbers greater than or less than a number

Calculate a running total

Count all of the cells in a range

Count the number of words in a cell or range

Conversion

Convert times

Convert dates stored as text to dates

Convert numbers stored as text to numbers

Convert measurements

Convert numbers to different number systems

Convert Arabic to Roman numerals

Text

Change the case of text

Check if a cell contains text (case-insensitive)

Check if a cell contains text (case-sensitive)

Combine text and numbers

Combine text with a date or time

Combine first and last names

Combine two or more columns by using a function

Repeat a character in a cell

Display only the last four digits of identification numbers

Remove spaces and nonprinting characters from text

Remove characters from text

Insert the current Excel file name, path, or worksheet in a cell

Split names by using the Convert Text to Columns Wizard

Split text among columns by using functions