Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero or negative rates and XNPV?
Hi,
Does anybody know why XNPV appears not to accept negative rates? e.g. using the example in the Excel 2003 help: (i.e. amounts = -10000, 2750, 4250, 3250, 2750, dates = 01 Jan 2008, 01 Mar 2008, 30 Oct 2008, 15 Feb 2009, 01 Apr 2009) returns #NUM! for rates 0 or below. That is =XNPV(0,amounts, dates). However when I composed a VBA function to duplicate the formula for XNPV, as shown in the help, the value is 3000 when the rate is zero. thanks, L. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions |