Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-17 Thread Jean-Baptiste Faure
Hi, Le 16/07/2012 19:14, marlon orlando barahona alvarez a écrit : > when we try to calculate the cube root of -27 (using the formula = > POWER (A1, 1/3) -3 Calc should give us but gives us the message # VALUE! > I solved the problem by modifying the formula as follows: > =-POWER (-A1, 1/3) and th

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-17 Thread Lionel Elie Mamane
On Tue, Jul 17, 2012 at 10:44:59PM +0200, Albert Thuswaldner wrote: > On Tue, Jul 17, 2012 at 8:29 PM, marlon orlando barahona alvarez > wrote: >> Is dificult add this correction to Calc? I have seen reports of this bug >> with date 2004. > I have read the bug report you mentioned: > https://iss

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-17 Thread Albert Thuswaldner
Hi, On Tue, Jul 17, 2012 at 8:29 PM, marlon orlando barahona alvarez wrote: > Is dificult add this correction to Calc? I have seen reports of this bug > with date 2004. > I have read the bug report you mentioned: https://issues.apache.org/ooo/show_bug.cgi?id=37129 and I tend to agree with the c

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-16 Thread Albert Thuswaldner
On Mon, Jul 16, 2012 at 10:18 PM, Ruslan Kabatsayev wrote: > On Mon, Jul 16, 2012 at 11:13 PM, Albert Thuswaldner > wrote: >> Sorry, It was a long time since I went to the university, but I if I'm >> correct you want to calculate: >> (-27)^(1/3) (note it is the same as 3x(-1)^(1/3) which to my mi

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-16 Thread Ruslan Kabatsayev
On Mon, Jul 16, 2012 at 11:13 PM, Albert Thuswaldner wrote: > Sorry, It was a long time since I went to the university, but I if I'm > correct you want to calculate: > (-27)^(1/3) (note it is the same as 3x(-1)^(1/3) which to my mind > results in an complex number (not -3) thus the #VALUE!. > > ju

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-16 Thread Albert Thuswaldner
On Mon, Jul 16, 2012 at 7:14 PM, marlon orlando barahona alvarez wrote: > when we try to calculate the cube root of -27 (using the formula = POWER > (A1, 1/3) -3 Calc should give us but gives us the message # VALUE! Sorry, It was a long time since I went to the university, but I if I'm correct yo

Re: A solution to calculation of odd roots of negative numbers with Calc

2012-07-16 Thread Regina Henschel
Hi Marlon, marlon orlando barahona alvarez schrieb: when we try to calculate the cube root of -27 (using the formula = POWER (A1, 1/3) -3 Calc should give us but gives us the message # VALUE! I solved the problem by modifying the formula as follows: =-POWER (-A1, 1/3) and this modification Calc

A solution to calculation of odd roots of negative numbers with Calc

2012-07-16 Thread marlon orlando barahona alvarez
when we try to calculate the cube root of -27 (using the formula = POWER (A1, 1/3) -3 Calc should give us but gives us the message # VALUE! I solved the problem by modifying the formula as follows: =-POWER (-A1, 1/3) and this modification Calc can give us the correct answer. Well I think to include