[Libreoffice-bugs] [Bug 112177] NPER function not working as anticipated following example in excel ( which works in google sheets)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112177

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
The lines from the patch

> +    else if ( fPmt == 0.0 )
> +        PushIllegalArgument();  // No payment, future value can never be reached

don't take into account that future value can be reached not only by payments,
but also by accumulated interest

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170902/cc233ffe/attachment.html>