# Predictive calculations

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

1. ## Predictive calculations

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

2. ## Re: Predictive calculations

What FORECAST formula did you try?

3. ## Re: Predictive calculations

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

4. ## Re: Predictive calculations

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)

5. ## Re: Predictive calculations

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

A
B
C
D
E
1
20002001200220032004
2
1315131111
3
15192158
4
1122151315
 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.

6. ## Re: Predictive calculations

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

Thanks again folks;

JohnK

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•