financial functions - HELP!!!

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

Guest

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?
 
One way:

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

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