Hi,

Myself and a colleague have been trying to work out how to calculate
the number of years it will take to achieve a target value (which
grows at a seperate slower rate) given a pre-defined start value and
fixed growth using a single formula and just did it...and really felt
the need to tell someone!!

Start Value B4 = 14216
Growth Rate B5 = 1.07
Target Value B6 = 17750
Growth Rate B7 = 1.02

Duration: =LOG(((B6*B7^B10)/B4),B5)

Am sure there are better ways and any high school student could have
done this but we're old so we feel dead chuffed!! Anyway, glad to get
that out of the system :-)

Best Regards,

CalumMurdo Kennedy