FORECAST() function help

[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.

 

[Frank Kabel]

Hi
try in E2 (B22 stores your data):
=FORECAST(2003,B22,$B$1:$D$1)

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