Practice free

IMPOWER function

IMPOWER raises a complex number to a power and returns the result as text. Tiny floating-point noise can show up in the real part, such as 1.2E-16.

Example

Read it as a sentence: square the complex number 1+i, then keep only the imaginary part, which gives 2.

Practice this in the app

Syntax

IMPOWER(inumber, number)

inumber (required)
A complex number as text, like "3+4i".
number (required)
The power to raise it to; can be fractional or negative.

Returns: The result as text.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=IMPOWER("3+4i",2) -7+24i (3+4i)^2
=IMPOWER("-4",0.5) 1.22514845490862E-16+2i Power 0.5
=IMPOWER("3+4i",0) 1 Power 0
=IMPOWER("1+i",-1) 0.5-0.5i Negative power
=IMPOWER("2","3") 8 Text number power
=IMPOWER("i",{1,2,3,4}) 6.1257422745431E-17+i Spill
=IMPOWER(0,0) #NUM! 0^0
=IMPOWER(0,-1) #NUM! 0^-1

Watch out for

  • Floating-point noise can show up in the real part, e.g. 1.2E-16.
  • Result is text.

Where it works

Excel
IMPOWER is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .