Compound Interest (growth rate) help needed

M

matthews01

I want to have a function to help me with this problem. I want to input into a cell A1 a growth rate, say 100% per year, and have it give me in cell A2 what I need to grow each month. If I need to use more cells than this that is fine...thanks for the help. I can be reached at [email protected]
 
N

Norman Harker

Hi Matthews01!

Use:

=(1+A1)^(1/12)-1

Or using the RATE function

=RATE(12,0,-1,1+A1,0,0)
 
Top