| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rate function
Getting #Num1 error for the rate function for 200000-PV -41067-PMT, and
20-years the rate is 20% . Excel is not calculating the rate. I can use my financial calculator and get an answer. Note: This does work for 15 years. I tried experimenting with the iterations under excel options under calculation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use RATE function? | Excel Discussion (Misc queries) | |||
| Rate function with #Num! result | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| a function giving the interest rate for inv x for period y & bal z | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
