FormulaCamp
Completed
3. Formula Basics · First Formulas · 15 min

1. Your First Formula

Lesson 1 of 14
Task 1 of 2
  1. In D2, calculate the total for bread: price × quantity.

Lesson theory

Every formula starts with an equals sign =. Instead of numbers, use cell addresses: =B2*C2. Then, when a price changes, the total recalculates on its own.

Tip: while you are typing a formula, click a cell and its address is inserted for you.

fx

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page