Search all of Office.com
 
Support / Excel / Excel 2003 Help and How-to / Working with Data / Formulas / Common Formulas
 
 

Examples of commonly used formulas

Applies to: Microsoft Office Excel 2003

 

Try Office 2010 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

Add dates
Add times
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

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

Top of Page Top of Page

 
 

See Also