When forecasting the future there is no right answer. If there was I would be
rich by now. There are any number of different algorythms that forecast the
future.

You can try the forecast function but I can't imagine that it will get you
what you want. =forecast(...)

You can do a search on interpolation to see if that helps. The linest
function comes to mind. =linest(...)

You could try Yoda but if I recall he had difficulty seeing the future.
--
HTH...

Jim Thomlinson


"sfranger2003" wrote:

This is particularly and exercise, so please no one get offended or heated.
I have a range of years and percentages, but I can't recognize a formula that
will determine the missing values for the months yet to be determined. For
example, Sep 2001 79.7%, Oct 2001 86.4%, Nov 2001 86.2%, and so on. What is
the simplest formula to get the missing values for the months and years to
come?