[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