In this article
IMPOWER raises a complex number to a power.
Advertisement
Syntax
=IMPOWER(inumber, number)| Argument | What it means |
|---|---|
inumber… |
Complex numbers as text |
Examples
Example 1
=IMPOWER(A2,2)Result: -7+24i. See the worked example table below for more cases.
IMPOWER in practice
Where you will use it
- Series and parallel impedance
- Ohm's law with phasors
- Coursework
Worked example
| z | Formula | Result |
|---|---|---|
| 3+4i | =IMPOWER(A2,2) | -7+24i |
| 1-i | =IMPOWER(A3,2) | 1.22514845490862E-16-2i |
| 2i | =IMPOWER(A4,2) | -4+4.90059381963448E-16i |
Results calculated in Excel. Tiny values like 1.22E-16 are floating-point rounding: read them as 0 (so (1-i)^2 = -2i). Wrap with IMREAL/IMAGINARY and ROUND if you need clean numbers.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Number instead of text | Plain numbers work as real values, but complex ones must be text |
| Division by 0 | #NUM! |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong