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)
=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)