financial functions - HELP!!!

B

Birks

I cannot find the right function to solve for the number of years it takes
for money to double given interest as a variable. It's a simple calculation,
but there does not seem to be a function for it. Input terms:

Amount of money
Interest rate

Ideas anyone?
 
J

JE McGimpsey

One way:

=NPER(x%, 0, 1, -2)

Note that amount of money is irrelevant to the calculation.
 
Top