Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difficulty in transposing | New Users to Excel | |||
VLOOKUP Difficulty | Excel Discussion (Misc queries) | |||
difficulty with Search function that incorporates multiple workshe | Excel Discussion (Misc queries) | |||
Price Function - Difficulty in understanding the formula | Excel Worksheet Functions | |||
IF Statement difficulty | Excel Worksheet Functions |