#VALUE! error in nper?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

#VALUE! error in nper?

Scott Ballantyne
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
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: #VALUE! error in nper?

Morten Welinder-2
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 <[hidden email]> 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
> [hidden email]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: #VALUE! error in nper?

GnuMeric mailing list
On Mon, May 8, 2017 at 11:24 AM, Scott Ballantyne <[hidden email]> wrote:
>> This seems a bug:

I don't think so.

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


I reckon the bug report is mistaken in at least two ways.

1) For starters, to get a meaningful result, it is almost certainly necessary
 for the "pmt" field to be negative.

2) The #VALUE! result is correct in cases where the pmt is insufficient to
 keep up with the accrued interest.  Here are the results I get, which do
 not seem erroneous in any obvious way, although the negative results require
 thoughtful interpretation:

A B C D E F G
-9.295 =nper(C1,D1,E1) 7.75% 50000 646000 7.740% =D1/E1
-9.284 7.75% 50000 645000 7.752%
                                                       
#VALUE! 7.75% -50000 646000 -7.740%
111.115 7.75% -50000 645000 -7.752%

_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: #VALUE! error in nper?

Scott Ballantyne
Yes, my apologies. I used nper(7.75%, 50000, -6460000) and -645000, to
determine the number of periods of spending before the money ran
out. I must say it never occured to me that the money would never run
out.



>
> On Mon, May 8, 2017 at 11:24 AM, Scott Ballantyne <[hidden email]> wrote:
> >> This seems a bug:
>
> I don't think so.
>
> >> 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 :(
>
>
> I reckon the bug report is mistaken in at least two ways.
>
> 1) For starters, to get a meaningful result, it is almost certainly necessary
>  for the "pmt" field to be negative.
>
> 2) The #VALUE! result is correct in cases where the pmt is insufficient to
>  keep up with the accrued interest.  Here are the results I get, which do
>  not seem erroneous in any obvious way, although the negative results require
>  thoughtful interpretation:
>
> A B C D E F G
> -9.295 =nper(C1,D1,E1) 7.75% 50000 646000 7.740% =D1/E1
> -9.284 7.75% 50000 645000 7.752%
>
> #VALUE! 7.75% -50000 646000 -7.740%
> 111.115 7.75% -50000 645000 -7.752%
>
> _______________________________________________
> gnumeric-list mailing list
> [hidden email]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Loading...