https://bugs.documentfoundation.org/show_bug.cgi?id=173408
Jürgen Kirsten <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #2 from Jürgen Kirsten <[email protected]> --- The example given does indeed produce an error, as the interest payment (156 currency units, calculated as 2600 * 6%) is higher than the principal repayment of 153.75. This means that the loan continues to grow and can never reach the target value of 0 currency units. A working example would therefore be, for instance, =NPER(5%;-153.75;2600) → Result: 38.28 periods. My suggestion to amend the example in the help section will, in my view, not affect interoperability with other software suites. The aim is not to change how the function works, but merely to clarify which numbers, with which signs, should be used in the function. -- You are receiving this mail because: You are the assignee for the bug.
