I get neither an error nor the number you report. Please file a bug report at bugzilla.gnome.org with a sample sheet attached.
Morten On Mon, May 8, 2017 at 11:24 AM, Scott Ballantyne <s...@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 > https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
