Forecast function calculation method?

Hi,

Im thinking of incorporating the Forecast function into my budget spreadsheet but I just cannot figure out how Excel calculates the forecast figure.

I understand how to set it up but if I was to try to calculate that on paper, I'd be stumped. If I cannot understand how the function works then how can I incorporate it into spreadsheets right?

So the question is, does anyone understand how Excel calculates the answer please?

FORECAST() just does a linear extrapolation. It also does interpolation if
the desired point is internal. See Excel Help ( the picture is helpful )
--
Gary's Student


"Kayote" wrote:

>
> Hi,
>
> Im thinking of incorporating the Forecast function into my budget
> spreadsheet but I just cannot figure out how Excel calculates the
> forecast figure.
>
> I understand how to set it up but if I was to try to calculate that on
> paper, I'd be stumped. If I cannot understand how the function works
> then how can I incorporate it into spreadsheets right?
>
> So the question is, does anyone understand how Excel calculates the
> answer please?
>
>
> --
> Kayote
> ------------------------------------------------------------------------
> Kayote's Profile: http://www.excelforum.com/member.php...o&userid=33314
> View this thread: http://www.excelforum.com/showthread...hreadid=531371
>
>