Re: #VALUE! error in nper?

[Morten Welinder <mortenw gnome org>]

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 <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
> https://mail.gnome.org/mailman/listinfo/gnumeric-list