Purpose
Raise complex number to given power
Return value
Complex number as text
Syntax
=IMPOWER(inumber,number)- inumber - A complex number.
- number - Power to raise number.
How to use
The Excel IMPOWER function returns a complex number raised to a given power. The complex number is input as text, and must be in the form x + yi or x + yj.
For example:
=IMPOWER("1+2i",2) // returns "-3+4i"
In the example shown, the formula in D6, copied down, is:
=IMPOWER(B6,C6)
Notes:
- Only lowercase "j" and "i" are accepted by IMPOWER. Other values will result in the #NUM error.
- The number argument must be numeric
Related functions
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.
IMREAL Function
The Excel IMREAL function returns the real coefficient of a complex number in the form x + yi or x + yj.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.
