forecast function help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

method - 06 Oct 2004 00:23 GMT

Just to clarify that formula, am i right to say this?

=ROUND(FORECAST($E$1,B2:D2,$B$1:$D$1),0)

$E$1 - is selecting the forcast for year 2004

B2:D2 - is selecting all the data bar the years in the top row

$B$1:$D$1 - is being used to predict the outcome for 2004

Is that right?

Thanks again

Reply to this Message

Frank Kabel - 06 Oct 2004 06:11 GMT

Hi
B1:D1 are the x values there B2:D2 the associated y values are. Now the
first parameter is the x value for which you want to search for the
associated y value

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Just to clarify that formula, am i right to say this?
>
[quoted text clipped - 15 lines]
> method's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15030
> View this thread: http://www.excelforum.com/showthread.php?threadid=266448

Reply to this Message