# Percentages & growth (Excel lesson 4 of 45)

> Percentages are just decimals with a format applied.

Source: https://spreadsheetpractice.com/learn/percentages-and-growth · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Foundations"
- **Time:** about 7 minutes, 2 graded exercises
- **Functions:** `%`, `^`
- **Access:** free
- **Key formula:** `=(C2-B2)/B2`: Percent change

## How it works

Excel stores 25% as 0.25. Calculate with decimals and let the cell format show the percent sign. Don't multiply by 100.

Percent change is `(new − old) / old`. Growth compounds: a balance growing at rate r for n years ends at `start × (1 + r)^n`.

## Syntax

| Formula | What it does |
|---|---|
| `=(C2-B2)/B2` | Percent change |
| `=C2/B2-1` | Same result, shorter |
| `=B2*(1+C2)` | Add a % increase |
| `=B2*(1+C2)^D2` | Compound growth |

## Watch out for

- Multiplying by 100 and formatting as % shows 2,500% instead of 25%.
- A negative percent change means a decline. Check it against the raw numbers.

## The exercises

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

1. **Year-over-year change.** In D2, calculate the percent change from last year to this year. Fill down to D6.
2. **Compound growth.** In E2, calculate the ending balance: start × (1 + rate) raised to the number of years. Fill down to E5.

Previous: [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) · Next: [The IF function](https://spreadsheetpractice.com/learn/if-function)

---

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