financial functions - HELP!!!

[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?

 

[JE McGimpsey]

One way:

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

Note that amount of money is irrelevant to the calculation.

 

[Guest]

JE, I don't know why I couldn't figure it out; can' thank you enough!