IMPOWER function
a complex number raised to an integer power.
Engineering · Guided Excel example
Where can you use it?
Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.
Scenario in the workbook
Raise a complex number to a power. The square of the imaginary unit is −1.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 2i | 2 |
| 8 | i | 2 |
| 9 | 1+0i | 3 |
Record 1
=IMPOWER(A7,B7)Illustrative output-4
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=IMPOWER("i",2)Turkish Excel · tr-TR
=SANKUVVET("i";2)Expected result
“−1”
Worked examples
Raise a complex number to a power. The square of the imaginary unit is −1.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 2i | 2 |
| 8 | i | 2 |
| 9 | 1+0i | 3 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =IMPOWER(A7,B7) |
-4 |
| Record 2 | =IMPOWER(A8,B8) |
-1 |
| Record 3 | =IMPOWER(A9,B9) |
1 |