Re: Cube Root of Negative Numbers: ERROR

=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.


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