Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
PS ....
On Oct 17, 4:41*pm, I wrote: =nper((1 + rg / fg)^(fg / fw) * (1 - rw) - 1, 0, -pv, 0.0001) / fw [....] Setting NPER"s "fv" to 0.0001 is a kludge [...]. NPER does not work when I set "fv" to zero. Probably because we can reduce a number by a percentage almost infinitely (limited by computer arithmetic). It is probably good enough to use 0.01 or 0.005 for "fv". After all, this is only an approximation anyway. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complicated question, for me anyway! :) | Excel Worksheet Functions | |||
Complicated question | Excel Discussion (Misc queries) | |||
Complicated Question | Excel Worksheet Functions | |||
Complicated question... | Excel Worksheet Functions | |||
complicated sum formula question | Excel Worksheet Functions |