Real World Maths Busters

The Maths Behind Everyday Life

The story, the formula and a worked example — see exactly where this maths shows up in the world around you.

Back to all stories
Technology 3 min read

Spreadsheets Are Just Grids of Equations

Every cell can reference any other — creating a web of live calculations.

A spreadsheet is a grid where each cell can contain a formula that references other cells. Change one input and every dependent value recalculates instantly.

Dependency Chains

If A1=10, B1=A1×2 (=20), and C1=A1+B1 (=30), changing A1 to 15 updates B1 to 30 and C1 to 45. The spreadsheet traces the dependency graph automatically.

Sales tax calculation chain

  1. 1

    A1 = Price

    100

  2. 2

    B1 = Tax rate

    0.08

  3. 3

    C1 = A1 × B1

    100×0.08=8100 \times 0.08 = 8
  4. 4

    D1 = A1 + C1

    100+8=108100 + 8 = 108
Answer

Change A1 to 200 and D1 instantly becomes 216

The takeaway

Spreadsheets are live equation webs — change one cell and the whole sheet responds.

Back to all stories