Level 1Analyst HabitsPractice, 3 min
Year-over-year growth
The task
Revenue grew from 2025 to 2026. In D2, calculate year-over-year growth: the change divided by last year.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Metric | 2025 | 2026 | YoY growth |
| 2 | Revenue | $840,000 | $966,000 |