Microsoft 365
SupportOffice All Microsoft
Windows
Products
Surface
Devices
Xbox Search
What's new Deals
Excel Help & Training
Buy
/
Formulas & 365
Microsoft functions
/
Overview of formulas in Excel
Sign in
Account & billing
Templates
Overview of formulas in Excel
Article
More support
XLOOKUP
Article
VLOOKUP
Article
SUM function
Article
COUNTIF function
Article
IF function
Article
IFS
Article
Next:
Common uses of functions
Overview of formulas in Excel
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007
Get started on how to create formulas and use built-in functions to perform calculations and solve problems.
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between
a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more
about the differences.
Create a formula that refers to values in other cells
1. Select a cell.
2. Type the equal sign =.
Note: Formulas in Excel always begin with the equal sign.
3. Select a cell or type its address in the selected cell.
4. Enter an operator. For example, – for subtraction.
5. Select the next cell, or type its address in the selected cell.
6. Press Enter. The result of the calculation appears in the cell with the formula.
See a formula
1. When a formula is entered into a cell, it also appears in the Formula bar.
2. To see a formula, select a cell, and it will appear in the formula bar.
Enter a formula that contains a built-in function
1. Select an empty cell.
2. Type an equal sign = and then type a function. For example, =SUM for getting the total sales.
3. Type an opening parenthesis (.
4. Select the range of cells, and then type a closing parenthesis).
5. Press Enter to get the result.
Download our Formulas tutorial workbook
We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or
even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.
With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
Formulas in-depth
You can browse through the individual sections below to learn more about specific formula elements.
The parts of an Excel formula
Using constants in Excel formulas
Using references in Excel formulas
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.
See Also
Switch between relative, absolute and mixed references for functions
Using calculation operators in Excel formulas
The order in which Excel performs operations in formulas
Using functions and nested functions in Excel formulas
Define and use names in formulas
Guidelines and examples of array formulas
Delete or remove a formula
How to avoid broken formulas
Find and correct errors in formulas
Excel keyboard shortcuts and function keys
Excel functions (by category)
Need more help?
How can we help you?
Expand your skills Get new features first
EXPLORE TRAINING JOIN MICROSOFT INSIDERS
A subscription to make
the most of your time
Try 1 month free
Was this information helpful?
Yes
No
What's new Microsoft Store Education Enterprise Developer Company
Surface Pro 8 Account profile Microsoft in education Azure Microsoft Visual Studio Careers
Surface Laptop Studio Download Center Office for students AppSource Windows Dev Center About Microsoft
Surface Pro X Microsoft Store Office 365 for schools Automotive Developer Center Company news
support
Surface Go 3 Deals for students & Government Microsoft developer Privacy at Microsoft
Returns parents program
Surface Duo 2 Healthcare Investors
Order tracking Microsoft Azure in Channel 9
Surface Pro 7+ education Manufacturing Diversity and inclusion
Virtual workshops and Microsoft 365 Dev
Windows 11 apps training Financial services Center Accessibility
HoloLens 2 Microsoft Store Retail Microsoft 365 Security
Promise Developer Program
Flexible Payments Microsoft Garage
English (United States)
Sitemap
Contact Microsoft
Privacy
Terms of use
Trademarks
Safety & eco
About our ads
© Microsoft 2021
