ExcelFlux

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

RowAB
6InputSecond input
72i2
8i2
91+0i3
Record 1
=IMPOWER(A7,B7)

Illustrative output-4

See the inputs and instructions for all 3 examples

Copyable 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
Microsoft Excel reference