1 | Month | Sales | ||
|---|---|---|---|---|
2 | 1 | $15.53 | ||
3 | 2 | $19.99 | ||
4 | 3 | $20.43 | ||
5 | 4 | $21.18 | ||
6 | 5 | $25.93 | ||
7 | 6 | $30.00 | ||
8 | 7 | $30.00 | ||
9 | 8 | $34.01 | ||
10 | 9 | $36.47 | ||
11 | ||||
12 | ||||
13 | Month | Predicted Sales | Formula | |
14 | 10 | 41.74052172 | =GROWTH(B2:B10,A2:A10,A14:A16) | |
15 | 11 | 46.22712349 | ||
16 | 12 | 51.19598075 | ||
17 | ||||
18 | ||||
19 | Month | Predicted Sales | Formula | |
20 | 10 | 200.4823447 | =GROWTH(B2:B10,A2:A10,A20:A22, 0) | |
21 | 11 | 340.630668 | ||
22 | 12 | 578.7504737 | ||
23 |