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.
A
B
C
D
1
2
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .