https://bugs.documentfoundation.org/show_bug.cgi?id=100542
Bug ID: 100542
Summary: CUMIPMT function, type parameter
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
ODFF: CUMIPMT
Summary: Calculates a cumulative interest payment.
Syntax: CUMIPMT( Number rate ; Number periods ; Number value ; Integer start ;
Integer end ; Integer type )
Returns: Currency
Constraints: rate > 0; value > 0; 1 <= start <= end <= periods"
=CUMIPMT(0,055/12;24;5000;4;6;-1) -> returns -57,80 , should return #error
because type is 0 or 1
=CUMIPMT(0,055/12;24;5000;4;6;) -> returns -57,80 , should return #error
because type is 0 or 1 and not optional parameter
Checked in excel and excel return in both cases error.
--
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
