Cells and formulas · Your first formulaWorks in: all current Excel versions, Google Sheets
A cell that calculates
A formula makes a cell work something out for you. Every formula starts with =: that's how the spreadsheet knows to calculate instead of just storing what you type.
After the =, point at other cells by their address: the column letter, then the row number. C2 is column C, row 2, which here holds the $6.50 price of a sourdough loaf. Use + to add and - to subtract.
Why point at cells instead of typing the numbers? Because the formula keeps up: change the price in C2 and the answer changes with it.
=C2+C3
- Leaving out the
=: the cell then just shows the text C2+C3. - Typing the numbers, like
=6.5+2.8: right today, but it won't update when a price changes. - Writing the row first: it's always column letter, then row number (
C2, not2C).
What do a sourdough loaf and a croissant cost together? Tap Try it to make E2 add the two prices.
| 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 |
Tap Try it to type =C2+C3 into E2.
Go deeper: Spreadsheet formula basics