Excel IMPOWER Function

Using the Excel IMPOWER Function

Excel IMPOWER Function

Summary

The Excel IMPOWER function returns a complex number in text format x + yi or x + yj raised to a power.

See the COMPLEX function to convert real and imaginary coefficients into a complex number.

Syntax

=IMPOWER (inumber, number)

Syntax Breakdown

Inumber
Required. Complex number for which you want to raise to a power.

Number
Required. Power to which you want to raise the complex number. Number can be an integer, fractional, or negative value.

The function returns the #VALUE! error if number is non-numeric.

Usage Notes

IMPOWER returns a complex number in the x + yi or x + yj format to a given power.

The function returns the #NUM! error if a value besides "i" or "j" is entered.