https://bugs.documentfoundation.org/show_bug.cgi?id=100650
Bug ID: 100650
Summary: IPMT, parameter Type
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
ODF: IPMT
Summary: Returns the amount of an annuity payment going towards interest.
Syntax: IPMT( Number Rate ; Number Period ; Number Nper ; Number PV [ ; Number
FV = 0 [ ; Number Type = 0 ] ] )
... Type: the due date for the payments (optional). Zero if omitted. If type is
1, then payments are made at the beginning of each period. If type is 0, then
payments are made at the end of each period.
=IPMT(0,06/52; 30; 4*52; 8000; 0 ;2)
=IPMT(0,06/52; 30; 4*52; 8000; 0 ;-2) , should return #error, parameter type
is 0 or 1
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
