Hi,

Try this. E11 has 18,000 and D11 has 10,000. D11 has 2010 and D10 has 1985

=(E11/E10)^(1/(D11-D10))-1

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"1944-71222" wrote in message
...
Is there a function in Excell that can be used to calculate an
investment"s
compound growth rate? If so what is it and how do you use it?

For instance if someone invested $10,000 in 1985 and that investment was
worth $18,000 today is there a function in Excell that can be used to
determine that investment's compound growth rate?