Predictive calculations

[hviking]

I've run into a situation I can't seem to solve, so hopefully someone on here can figure it out.

I'm trying to "predict" what the next value would be, using previous years data.

I've got four colums, representing 4 years. A-D Then A2-A13, B2-B13 etc. Has the values for the months in that year.

I.e.

2000..2001..2002..2003..2004
13......15.......13.....11
15......19.......21.....5
11......22........15....13

Now I need for column E to have the predicted value for that year. Is there a simple way, or simple formula to do this? I tried using the FORECAST formula, but couldn't get it to work.

So do any of you know a way to do this?

Thanks;

JohnK

 

[Aladin Akyurek]

What FORECAST formula did you try?

 

[hviking]

I just tried using =FORECAST, then following the example in the Help section of Excel, but couldn't get any further than that. I just couldn't understand how they said to use it.

I also tried using =TREND, but that didn't not yield the results I was looking for. I've never used either of those before, so I'm totally lost.

Thanks;

JohnK

 

[scottlloyd33]

2000 2001 2002 2003 2004
13 15 13 11 11
15 19 21 5 8
11 22 15 13 15

Formula in e2 is as follows:

=FORECAST(E$1,A2:D2,A$1:D$1)

 

[Aladin Akyurek]

And with Trend...

=TREND(A2:D2,$A$1:$D$1,$E$1)

Book6
	A	B	C	D	E
1	2000	2001	2002	2003	2004
2	13	15	13	11	11
3	15	19	21	5	8
4	11	22	15	13	15
Sheet1

 

[hviking]

Worked like a charm. Makes a lot more sence than the help in Excel.

Thanks again folks;

JohnK