Hello,
  I'm using OpenOffice version 2.2.

The financial function NPER in Calc would appear  to be using
the wrong equation, at least for when fv is zero,  i.e.

 n = log(1 + pv * rate / pmt) / log(1 + rate)

The correct equation should be

 n = log(1 - pv * rate / pmt) / log(1 + rate)


Regards,

Paul Whitfield

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to