Friday, 23 November 2012

Forecast Function - Excel

Forecast future values based on historic trends
             =FORECAST(x,known Ys,known Xs)

E.G. = FORECAST(future date, known sales, known dates)
             =FORECAST(A12,$B$2:$B$11,$A$2:$A$11)




No comments:

Post a Comment