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

Alan G Isaac aisaac at american.edu
Wed Jun 17 17:47:32 EDT 2009

On 6/9/2009 1:14 AM josef.pktd at 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