financial functions - HELP!!!
 

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

financial functions - HELP!!!
 

One way:

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

Note that amount of money is irrelevant to the calculation.


In article ,
Birks wrote:

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?

financial functions - HELP!!!
 

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


"JE McGimpsey" wrote:

One way:

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

Note that amount of money is irrelevant to the calculation.


In article ,
Birks wrote:

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?