POWER Function

Raises a number to a power.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number

Want to practice POWER 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

POWER(number, power) is the same as number^power — 2 to the power 3 is 8.

Fractional powers give roots, which makes it useful for growth rates.

Syntax

=POWER(number, power) Explain

Arguments

ArgumentRequired?What it does
numberYesThe base number.
powerYesThe exponent.

Examples

Example 1 — Investment growth

$10,000 growing at 6% a year for each number of years.

B2fx=10000*POWER(1.06, A2)
AB
1YearsValue
2110600
3513382.26
41017908.48
=10000*POWER(1.06, A2) Explain

Example 2 — Average yearly growth (CAGR)

From 80,000 to 125,000 over 4 years.

=POWER(125000/80000, 1/4)-1 Explain

About 11.8% a year.

Common mistakes

  • Negative roots. POWER(−8, 1/3) returns #NUM! because Excel can't take fractional powers of negatives.

Notes

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.