ODF specification: 6.12.29 NPER Summary: Compute the number of payment periods for an investment. Syntax: NPER( Number Rate ; Number Payment ; Number Pv [ ; [ Number Fv ] [ ; Number PayType ] ] ) ... 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. =NPER(0,06/52; -175; 8000; 0 ;-1) =NPER(0,06/52; -175; 8000; 0 ;2) return result, should return #error. Last parameter only 0 or 1 is allowed.
(In reply to raal from comment #0) > =NPER(0,06/52; -175; 8000; 0 ;-1) > =NPER(0,06/52; -175; 8000; 0 ;2) > return result, should return #error. Last parameter only 0 or 1 is allowed. Yes, did not return error. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: ef47ce2397d4ed453fe01d994d13a13f442ec3bb CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on July 2nd 2016
Excel Fx help says it is a logical value, which we treat it as. Needs to be corrected in ODFF. https://lists.oasis-open.org/archives/office-comment/201607/msg00001.html
Setting to duplicate as negative values of argument PayType are handled as 0 (FALSE). *** This bug has been marked as a duplicate of bug 100646 ***