Excel equations...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Finding Equations 4
Can the displayed equation of a trendline be dynamic? 1
Excel What does E represent in Microsoft Excel?? 1
Iterative Equation 5
Excel 2007: continuously update scatter chart from scroll bars 1
how to calculate Root function in Excel ? 1
web based equations 3

Back
Top