IMPOWER Function
Raises a complex number to a power.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
Complex number text
Overview
IMPOWER returns a complex number raised to any real power — whole, fractional or negative. Excel works in polar form (size and angle), so results can carry tiny rounding leftovers.
The result is text, shown to 15 significant digits. Wrap it in IMREAL or IMAGINARY to get a number you can format or round.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| inumber | Yes | The complex number. |
| number | Yes | The power. 0.5 gives a square root, 1/3 a cube root. |
Examples
Example 1 — Powers and roots
Each row raises column A to the power in column B.
| A | B | C | |
|---|---|---|---|
| 1 | Complex | Power | Result |
| 2 | 2+3i | 3 | -46+9.00000000000001i |
| 3 | 3+4i | 0.5 | 2+i |
| 4 | 2 | 10 | 1024 |
The exact answer for the first row is −46+9i; the 0.00000000000001 is floating-point rounding, exactly as Excel shows it.
Common mistakes
- #NUM! The text isn't a valid complex number — for example a space ("3 + 4i"), a capital I, or a letter other than i or j.
- Tiny numbers like 1.2E-16. Floating-point rounding can leave a very small leftover where the exact answer is 0. Use IMREAL/IMAGINARY with ROUND if you need a clean figure.
- #NUM! for zero. 0 raised to zero or a negative power is undefined and returns #NUM!.
Notes
- Fractional powers return the principal root only: IMPOWER("-8",1/3) gives 1+1.73205080756888i, not −2.
- Related functions: IMSQRT, IMPRODUCT, IMEXP, POWER.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.