Examples of commonly used formulas

Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

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 time
Show dates as days of the week
Insert the current date and time in a cell
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
MODE function
Math Add numbers
Subtract numbers
Multiply and divide numbers
Calculate percentages
Round a number
POWER function
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