It may not be an error!

even though

1+1.73205080756888i

does not "look like"

-2

Say in C1 we enter:
=IMPOWER(B1,3)

we see displayed:
-8.00000000000003-2.03365969897452E-014i
this means the answer is really "close enough" within roundoff error.
--
Gary''s Student - gsnu200790


"monir" wrote:

Hello;

1) The cubic root of complex number "x+yi" is calculated using IMPOWER().
The w/s function appears to return incorrect values when the real
coefficient "x" is -ve.

2) For example:
A1:: -8+0i
B1::= IMPOWER(A1,1/3)
the function returns: 1. + 1.7320508i
instead of the correct value of -2.

3) The problem appears to be consistent with calculating theta [=atan(y/x)]
as "pi" instead of "0" for the above example "-8+0i"

How to fix the problem ?? According to Excel Help, the w/s function
IMPOWER() should work correctly regardless of the complex coefficients in A1
??

Thank you kindly.