Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×