Hi UncleD!
=(FV/PV)^(1/NPER)-1
So if 1000 increased to 1500 in 5 years:
=(1500/1000)^(1/5)-1
Returns: 8.44717711976985%
Or you can use the RATE function:
=RATE(5,0,-1000,1500,0,0)
Returns: 8.44717711976987%
The negative for PV indicates a payment out and the positive for the
FV represents a right to receive.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
