Forecast function Question

[jonhunt]

If I have the following data set in A,B,C and D.
Month 2007 2006 %
JAN 1,189 1,193 0%
FEB 1,249 954 31%
MAR 1,135 1,278 -11%
APR 1,046 1,257 -17%
MAY 748 1,188 -37%
JUN 1,058 1,343 -21%
JUL 849 1,170 -27%
AUG 838 1,126
SEP 1,001 1,346
OCT 974 1,309
NOV 1,024 1,377
DEC 1,065 1,432

Where percentage shows the gain or decline from the same month in 2006...is there a way to use the Forecast Function to predict the performance for the remaining months of 2007? I've looked up Forecast in help and it is very confusing to me.

Thanks,

[rylo]

Hi

Say your data as shown is in the range A1:D13, I'm assuming that you want to use forecast to get the values for the range D9:D13, and use those results to redo the range B9:B13. If so then

D9: =FORECAST(C9,$D$2:$D$8,$C$2:$C$8)
B9: =ROUND(C9*(1+D9),0)

Copy down to row 13.


HTH

rylo