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 | ||
8 | 7 | $30 | ||
9 | 8 | $34.01 | ||
10 | 9 | $36.47 | ||
11 | ||||
12 | ||||
13 | Month | Result | Formula | |
14 | 10 | 38.76388889 | =FORECAST(A14,$B$2:$B$10,$A$2:$A$10) | |
15 | 11 | 41.32688889 | =FORECAST(A15,$B$2:$B$10,$A$2:$A$10) | |
16 | 12 | 43.88988889 | =FORECAST(A16,$B$2:$B$10,$A$2:$A$10) | |
17 |