Level 3LET and LAMBDAPractice, 3 min
REDUCE: compound a year of growth
The task
Monthly growth bounced around all year. In D2, work out the growth for the whole year. Start
REDUCE at 1, multiply by (1 + growth) for each month in turn, then subtract 1 at the end.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Growth | Growth for the year | |
| 2 | Jan | 4.0% | ||
| 3 | Feb | 3.5% | ||
| 4 | Mar | 5.0% | ||
| 5 | Apr | -1.0% | ||
| 6 | May | 4.2% | ||
| 7 | Jun | 3.0% | ||
| 8 | Jul | 2.8% | ||
| 9 | Aug | -1.5% | ||
| 10 | Sep | 6.0% | ||
| 11 | Oct | 4.5% | ||
| 12 | Nov | 2.0% | ||
| 13 | Dec | 3.8% |