Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default Complicated FV Question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated question, for me anyway! :) Peter Doak Excel Worksheet Functions 2 March 18th 07 08:34 PM
Complicated question Jasdf Excel Discussion (Misc queries) 1 November 8th 06 01:08 PM
Complicated Question kyrospeare Excel Worksheet Functions 5 April 27th 06 02:45 AM
Complicated question... ozdemir Excel Worksheet Functions 3 December 7th 05 09:37 PM
complicated sum formula question Eric Excel Worksheet Functions 2 December 4th 05 04:30 AM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"