# Your first formula (Excel lesson 1 of 45)

> Every formula starts with an equals sign and points at cells, not numbers.

Source: https://spreadsheetpractice.com/learn/first-formula · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Foundations"
- **Time:** about 6 minutes, 2 graded exercises
- **Functions:** `+ − × ÷`, `( )`
- **Access:** free
- **Key formula:** `=B2*C2`: Multiply two cells

## How it works

A formula is a calculation that lives in a cell. Type `=` first, then build it from cell references like `B2`, operators, and functions. The cell shows the result; the formula bar shows the formula.

Reference cells instead of typing the numbers you see. `=B2*C2` recalculates the moment a quantity or price changes. `=3*4.5` never will. The grader checks for this: it re-runs your formula on different numbers.

Excel follows the usual order of operations: parentheses first, then exponents (`^`), then `*` and `/`, then `+` and `-`. When in doubt, add parentheses.

## Syntax

| Formula | What it does |
|---|---|
| `=B2*C2` | Multiply two cells |
| `=(B2+C2)/2` | Parentheses run first |
| `=B2^2` | B2 squared |

## Watch out for

- Without the = sign, Excel stores your formula as plain text.
- Typing the number you see (=3*4.5) works once and breaks when the data changes.
- While typing a formula, click a cell to insert its reference.

## The exercises

Solve them in the live grid at [Your first formula](https://spreadsheetpractice.com/learn/first-formula). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Line totals.** In D2, multiply the quantity by the unit price. Then fill the formula down to D5.
2. **Order of operations.** In D2, average the midterm and final by adding them and dividing by 2. Fill down to D6. Skip the AVERAGE function for now; this one is about parentheses.

Next: [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
