Microsoft Office Assistance: Examples of commonly used formulas
Click here to switch to other Office Online sites worldwideUnited States (change)
|
  
 
 Home 
 Assistance 
 Training 
 Templates 
 Clip Art and Media 
 Downloads 
 Office Marketplace 
 Work Essentials 
 Microsoft Office System 
 Deployment Center 
   
Things To Do
Suggest new content
Get answers from other Office users
Get our newsletter
Contact Us
Examples of commonly used formulasHelp
Assistance > Excel 2003 > Working with Data > Formulas > Common Formulas
 
Type of FormulaExample

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 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 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 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 in a cell
Split names by using Convert Text to Columns
Split text among columns by using functions
See Also
*Office Discussion: Discussions in Excel Worksheet Functions
*Office Discussions: Discussions in Excel General Questions
*Summing up ways to add and count Excel data
 

  Printer-friendly version
Accessibility | Contact Us | Free Newsletter | Office WorldwideClick here to switch to other Office Online sites worldwide
© 2006 Microsoft Corporation. All rights reserved.  Legal | Trademarks | Privacy Statement