forecast function help

  • Thread starter Thread starter method
  • Start date Start date
M

method

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
 
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
 
Back
Top