Excel equations...

What is the equation used in calculating interest compounded for a value
representing years?

Not sure this is exactly what you are seeking. This is the formula for
compound annual growth rate.

=(EndValue/StartValue)^(1/3)-1

KS

"thanatologist" wrote:

> What is the equation used in calculating interest compounded for a value
> representing years?

Most people would use the FV function to calculate the future value of the
amount. If you want just the interest, then subtract the present value from
this result.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"thanatologist" <thanatologist@discussions.microsoft.com> wrote in message
news:EC01CF7F-5F82-450D-8D37-E82860C8AC24@microsoft.com...
> What is the equation used in calculating interest compounded for a value
> representing years?