Exercises / Foundations · 10 of 12
Growth from last year
Percent change is (new − old) ÷ old. The brackets matter: without them Excel divides first. A result of 0.25 means up 25%, −0.1 means down 10%.
Your taskIn D2, work out the change from last year (B2) to this year (C2) as a fraction of last year. It will be copied down to D6.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Product | Last year | This year | Change | ||
| 2 | Laptops | 1200 | 1380 | |||
| 3 | Tablets | 860 | 774 | |||
| 4 | Phones | 2450 | 2940 | |||
| 5 | Monitors | 640 | 688 | |||
| 6 | Headsets | 1100 | 935 | |||
| 7 | ||||||
| 8 | ||||||
| 9 |