> =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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
