What FORECAST formula did you try?
This is a discussion on Predictive calculations within the Excel Questions forums, part of the Question Forums category; I've run into a situation I can't seem to solve, so hopefully someone on here can figure it out. I'm ...
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
What FORECAST formula did you try?
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
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)
And with Trend...
=TREND(A2:D2,$A$1:$D$1,$E$1)
******** ******************** ************************************************************************>
Microsoft Excel - Book6 ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
=
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 *
[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
Worked like a charm. Makes a lot more sence than the help in Excel.
Thanks again folks;
JohnK
Like this thread? Share it with others