The Excel IMPOWER function returns a complex number raised to a given power. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts
Syntax:= IMPOWER (inumber, number)
The IMPOWER function syntax has the following arguments:
- Inumber: Required. A complex number you want to raise to a power.
Number: Required. The power to which you want to raise the complex number
Example: Let’s look at some Excel IMPOWER function examples and explore how to use the IMPOWER function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following IMPOWER examples would return:
Use COMPLEX to convert real and imaginary coefficients into a complex number.
- If number is nonnumeric, IMPOWER returns the #VALUE! error value.
- Number can be an integer, fractional, or negative.
A complex number raised to a power is calculated as follows: where: and: and: