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
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The base number. |
| power | Yes | The exponent. |
Examples
Example 1 — Investment growth
$10,000 growing at 6% a year for each number of years.
B2fx=10000*POWER(1.06, A2)
| A | B | |
|---|---|---|
| 1 | Years | Value |
| 2 | 1 | 10600 |
| 3 | 5 | 13382.26 |
| 4 | 10 | 17908.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

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.