IMPOWER Function

Raises a complex number to a power.

Category

Engineering

Available in

All versions, Microsoft 365

Returns

Complex number text

Want to practice IMPOWER in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=IMPOWER(inumber, number) Explain

Arguments

ArgumentRequired?What it does
inumberYesThe complex number.
numberYesThe 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.

C2fx=IMPOWER(A2,B2)
ABC
1ComplexPowerResult
22+3i3-46+9.00000000000001i
33+4i0.52+i
42101024
=IMPOWER(A2,B2) Explain

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.
Kyle Stott

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.