Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to / Formula and name basics / Examples of formulas
 
 

Examples of commonly used formulas

Applies to: Microsoft Office Excel 2007

 
Type of Formula Example

Conditional

Create conditional formulas
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 or subtract dates

Add or subtract units of time
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
Find the most frequent number in 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 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

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

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
 
 

See Also