Cube Root of Negative Numbers: ERROR
- From: Leonard Mada <discoleo gmx net>
- To: gnumeric-list gnome org
- Subject: Cube Root of Negative Numbers: ERROR
- Date: Thu, 22 Feb 2007 20:41:57 +0200
*The Cube Root of Negative Numbers returns an ERROR*
It seems that gnumeric cannot calculate the cube root of negative
numbers. I have tested a couple of programs and found these results:
=POWER(-27, 1/3) returns
#VALUE! in OOo 2.1
#NUM! in gnumeric 1.7.6
"-3" in MS Excel XP => TRUE
R returns an ERROR, too: (-27)^(1/3) returns "NaN".
Seems, a lot of software gets it wrong, though Excel manages to calculate it.
I hope therefore, that this gets corrected in gnumeric, too. Should I post it as a BUG?
Kind reagrds,
Leonard Mada
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]