FORECAST() function help

  • Thread starter Thread starter method
  • Start date Start date
M

method

This might seem a bit newbie but im having trouble with the forecast
function.

Say for example i have a collection of data for sales of each item over a
number of years:

item 2000 2001 2002 2003

1 3 4 5
2 4 3 2
3 2 2 4
4 3 1 5
5 4 1 6
6 2 2 4

i am asked to forcast the values for the year 2003. I have read and looked
at many examples on how to do this and still can't work out where to start?
Any help would be great, thank you.
 
Hi
try in E2 (B2:D2 stores your data):
=FORECAST(2003,B2:D2,$B$1:$D$1)

Be sure that you're aware of the underlying logic of this function
(linear interpolation)
 
Back
Top