Re: Cube Root of Negative Numbers: ERROR

["Morten Welinder" <mwelinder gmail com>]

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