https://bugs.documentfoundation.org/show_bug.cgi?id=100689
Bug ID: 100689
Summary: PMT function, PayType, Nper parameter
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r...@post.cz
ODF definition:
PMT
Summary: Compute the payment made each period for an investment.
Syntax: PMT( Number Rate ; Integer Nper ; Number Pv [ ; [ Number Fv = 0 ] [ ;
Number PayType = 0 ] ] )
Returns: Currency
Constraints: Nper > 0
Semantics: Computes the payment made each period for an investment. The
parameters are:
Rate: the interest rate per period.
Nper: the total number of payment periods.
Pv: the present value of the investment.
Fv: the future value of the investment; default is 0.
PayType: the type of payment, defaults to 0. It is 0 if payments are due at the
end of the period; 1 if they are due at the beginning of the period. With
PayType=1 the first payment is made on the same day the loan is taken out.
=PMT(0,0199/12;36;25000;0;2) should be error: PayType is 0 or 1
=PMT(0,0199/12;-36;25000;0;0) should be error: Constraints: Nper > 0
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs