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.

Syntax
=C2+C3
Common mistakes
  • 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, not 2C).

What do a sourdough loaf and a croissant cost together? Tap Try it to make E2 add the two prices.

ABCDE
1ItemSoldPriceTotalBasket
2Sourdough loaf14$6.50
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$7.00

Tap Try it to type =C2+C3 into E2.

Go deeper: Spreadsheet formula basics