Re: #VALUE! error in nper?

I get neither an error nor the number you report.

Please file a bug report at with a sample sheet attached.


On Mon, May 8, 2017 at 11:24 AM, Scott Ballantyne <sdb ssr com> wrote:
This seems a bug:

nper(7.75%,50000,646000) -> #VALUE!
nper(7.75%,50000,645000) -> 111

Seems anything greater than 646000 for PV causes this error, which is
very unfortunate for me :(

gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]