Re: Cube Root of Negative Numbers: ERROR
- From: "Morten Welinder" <mwelinder gmail com>
- To: "Leonard Mada" <discoleo gmx net>
- Cc: gnumeric-list gnome org
- Subject: Re: Cube Root of Negative Numbers: ERROR
- Date: Thu, 22 Feb 2007 17:20:18 -0500
=POWER(-27, 1/3) returns
#VALUE! in OOo 2.1
#NUM! in gnumeric 1.7.6
You can mathematically define x^(p/q) for negative x and integers p and q odd,
but there is not way to tell if a floating point value was meant to
represent such a
value. By the time the result of 1/3 gets to the power function it
sure is *not*
p/q with odd p,q.
So, don't bother reporting it. It is an unavoidable problem with using
numbers with finite precision. If you want to do that calculation don't do it
that way.
Morten
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]