Spreadsheet formula basics
Updated · Works in: all current Excel versions, Google Sheets · Every example checked before release
Short answer
Start every formula with =, then point at cells instead of typing their values: =B2*C2. Use + - * / ^; multiplication and division happen before addition, so add brackets when you mean otherwise: =(C2+C3)/2.
A formula is a calculation that lives in a cell and updates when the cells it uses change. Every formula starts with =; after that it's references, numbers and operators. Each example below is a live sheet: change the formula and watch it recalculate.
Start with = and point at cells
=B2*C2 multiplies the value in B2 by the value in C2. Use references instead of typing the numbers: if B2 changes, the result follows.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Sold | Price | Total |
| 2 | Sourdough loaf | 14 | $6.50 | $91.00 |
| 3 | Croissant | 32 | $2.80 | |
| 4 | Cinnamon bun | 21 | $3.20 | |
| 5 | Baguette | 18 | $3.00 | |
| 6 | Rye loaf | 9 | $7.00 |
The operators
+ add, - subtract, * multiply, / divide, ^ power, and & joins text. Comparisons (=, <>, >, <, >=, <=) return TRUE or FALSE. A % after a number divides it by 100, so =C2*10% is 10% of C2.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Sold | Price | Total |
| 2 | Sourdough loaf | 14 | $6.50 | |
| 3 | Croissant | 32 | $2.80 | |
| 4 | Cinnamon bun | 21 | $3.20 | |
| 5 | Baguette | 18 | $3.00 | |
| 6 | Rye loaf | 9 | $7.00 | |
| 7 | Total sold | 94 |
Order of operations
Multiplication and division happen before addition and subtraction, so =C2+C3/2 divides first. Brackets change the order: =(C2+C3)/2 is the average of the two prices.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Sold | Price | Total |
| 2 | Sourdough loaf | 14 | $6.50 | |
| 3 | Croissant | 32 | $2.80 | |
| 4 | Cinnamon bun | 21 | $3.20 | |
| 5 | Baguette | 18 | $3.00 | |
| 6 | Rye loaf | 9 | $7.00 | |
| 7 | Average of two | $4.65 |
Check yourself
One real exercise from the “Cells and formulas” unit. Checked on our server; no account needed.Another customer buys a baguette and a rye loaf. In E2, add the baguette price (C5) and the rye loaf price (C6).
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Sold | Price | Total | Basket |
| 2 | Sourdough loaf | 14 | $6.50 | ||
| 3 | Croissant | 32 | $2.80 | ||
| 4 | Cinnamon bun | 21 | $3.20 | ||
| 5 | Baguette | 18 | $3.00 | ||
| 6 | Rye loaf | 9 | $7.00 |
Common mistakes
Forgetting the
=: the cell then stores the text “B2*C2”.Typing the result (89.6) instead of a formula, so it never updates.
Relying on order of operations without brackets when you mean “add first”.
Questions
Why does my formula show as text?+
Either it doesn't start with =, or the cell was formatted as Text before you typed. Set the format to General and re-enter the formula.
Is the syntax the same in Excel and Google Sheets?+
Yes for everything on this page: =, cell references and the operators work the same way in both.
Reading is step one. Now make it stick.
Practise it in a five-minute lesson on a live sheet, with instant feedback. No account needed for the free units.