
Tutorials
Excel Formulas for Beginners: A Simple Guide With Examples
New to Excel formulas? Learn how formulas work, the math operators, the six functions to learn first and how to fix common errors.
By ExcelPanda Team · Published · 6 min read
How an Excel formula works
Click a cell, type =, then write what you want Excel to work out. Press Enter and the cell shows the result while the formula stays visible in the formula bar.
=A2+B2Here Excel adds whatever is in A2 and B2. Change either number and the answer updates by itself, which is the whole point of using formulas.
Math operators
Math operators in Excel
| Operator | What it does | Example |
|---|---|---|
| + | Add | =A2+B2 |
| - | Subtract | =A2-B2 |
| * | Multiply | =A2*B2 |
| / | Divide | =A2/B2 |
| ^ | Power | =A2^2 |
Excel works out multiplication and division before addition and subtraction. Use brackets to change the order: =(A2+B2)*C2.
The functions to learn first
Functions most beginners need first
| Function | What it does | Example |
|---|---|---|
| SUM | Adds up numbers | =SUM(B2:B10) |
| AVERAGE | Finds the average | =AVERAGE(B2:B10) |
| COUNT | Counts cells that hold numbers | =COUNT(B2:B10) |
| MIN / MAX | Smallest / largest value | =MAX(B2:B10) |
| IF | Returns one value or another | =IF(B2>=50,"Pass","Fail") |
| ROUND | Rounds a number | =ROUND(B2,1) |
A range such as B2:B10 means every cell from B2 down to B10. For the IF function in more depth, read our IF function guide.
Use cell references, not typed numbers
Instead of typing =1200*0.2, put 1200 in one cell and 0.2 in another, then point at them. When the numbers change, every formula that uses them updates. By default, references shift when you copy a formula. To stop a reference moving, lock it with dollar signs, as in $B$1. Our guide to absolute and relative references covers this properly.
Common formula errors
- #DIV/0! means you divided by zero or by an empty cell.
- #NAME? usually means a typo in a function name or text without quotation marks.
- #VALUE! means a formula expected a number and found text.
- #REF! means the formula points at a cell that was deleted.
- #N/A means a lookup could not find what you asked for.
Tips for writing formulas
- Click cells instead of typing their addresses. Excel fills in the reference for you.
- Press F2 on a cell to edit it. Excel colour-codes the cells it refers to.
- Check totals by eye with a quick estimate before you trust a formula.
Not sure what to learn next? The most important Excel functions post gives you an order.
Frequently asked questions
Why does every Excel formula start with an equals sign?
The equals sign tells Excel that what follows is a calculation, not text. Without it, Excel just displays what you typed.
What is the difference between a formula and a function?
A formula is anything you type after the equals sign, such as =A1+B1. A function is a built-in tool you can use inside a formula, such as SUM or IF.
How do I copy a formula down a column?
Select the cell with the formula and drag the small square in its bottom-right corner down, or select the range and press Ctrl+D (Cmd+D on a Mac).
Why does my formula show the formula text instead of the answer?
The cell is probably formatted as Text, or there is a leading apostrophe or space. Set the format to General and enter the formula again.
Sources and disclaimers
ExcelPanda is not affiliated with or endorsed by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.
.png)