#VALUE! error in nper?

From: Scott Ballantyne <sdb ssr com>
To: gnumeric-list gnome org
Subject: #VALUE! error in nper?
Date: 8 May 2017 15:24:00 -0000

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 :(

Follow-Ups:
- Re: #VALUE! error in nper?
  - From: Morten Welinder

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