View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monir monir is offline
external usenet poster
 
Posts: 215
Default Difficulty with IMPOWER() Worksheet Function

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.