| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Financial functions | Excel Worksheet Functions | |||
| What is the meanding of the term €¢ Financial Functions | Excel Worksheet Functions | |||
| financial functions dll | Excel Worksheet Functions | |||
| Financial Functions | Excel Worksheet Functions | |||
| Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Linear Mode
