Examples of commonly used formulas

The following table contains links to articles and videos that show you how to create formulas from the data in your worksheet. The examples in the articles contain sample data to get you started and guidance to help you get the results you expect.

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
	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 and 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 two or more columns by using a function
	Repeat a character in a cell
	Display only the last four digits of identification numbers
	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

Top of Page