formulastreak

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.

Saturday bakery stall · edit D2 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultD2 = $91.00
ABCD
1ItemSoldPriceTotal
2Sourdough loaf14$6.50$91.00
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$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.

Saturday bakery stall · edit B7 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultB7 = 94
ABCD
1ItemSoldPriceTotal
2Sourdough loaf14$6.50
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$7.00
7Total sold94

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.

Saturday bakery stall · edit C7 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultC7 = $4.65
ABCD
1ItemSoldPriceTotal
2Sourdough loaf14$6.50
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$7.00
7Average 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).

Select E2 and type = to start its formula (in the cell or the formula bar)
ABCDE
1ItemSoldPriceTotalBasket
2Sourdough loaf14$6.50
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$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.

Practise it now