Examples of commonly used formulas

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

 In Excel 2010, entering and editing formulas and using functions in formulas is easier, thanks to improvements to the formula bar and Function AutoComplete.Read an article or try Office 2010!

This article provides links to topics that show you detailed examples of the various types of formulas that you can create in Excel.

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 a cell

Lookup

Look up values in a range

Date and Time

Calculate the difference between two dates
Calculate the difference between two times
Count days before a date
Show dates as the day 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 numbers

Calculate the median of a group of numbers
Calculate the mode of a group of numbers

Math

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 of a number
Create a multiplication table

Counting

Count cells that contain numbers

Count nonblank cells
Count how often a value occurs
Count occurrences of values or unique values in a data range
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
Compare cell contents
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 from the beginning and end of a cell
Remove characters from text
Insert the current Excel file name in a cell
Split names by using Convert Text to Columns
Split text among columns by using functions

Applies to:
Excel 2003