[Numpy-discussion] OT NPER in Gnumeric (was: Definitions of pv, fv, nper, pmt, and rate)

Alan G Isaac aisaac@american....
Wed Jun 17 16:47:32 CDT 2009


On 6/9/2009 1:14 AM josef.pktd@gmail.com quoted:
> Note: Gnumeric gives an error for negative rates. Excel and OOo2 do
> not. For NPER(-1%;-100;1000), OOo2 gives 9.48, Excel produces
> 9.483283066, Gnumeric gives a #DIV/0 error. This appears to be a bug
> in Gnumeric.


Recently fixed (in Gnumeric).

Alan Isaac




More information about the Numpy-discussion mailing list