# POWER function in Excel

> POWER raises a number to a power, the same as the ^ operator.

Source: https://spreadsheetpractice.com/functions/power · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** POWER raises a number to a power, the same as the ^ operator.
- **Syntax:** `=POWER(number, power)`
- **Most common use:** `=POWER(B2,2)` returns 144 (Area of a 12 ft square: 144)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** number raised to power.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

POWER raises a number to a power, the same as the ^ operator. Use it for squares and cubes, compound growth (1 + rate raised to the number of years), and roots, since a fractional power such as 1/3 is a cube root.

## Syntax

`=POWER(number, power)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The base number. |
| `power` | Required | The exponent to raise it to. Fractions give roots: 1/2 is a square root. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=POWER(B2,2)` | 144 | Area of a 12 ft square: 144 |
| D3 | `=POWER(1+B3,B4)` | 1.338225578 | Growth factor after 5 years at 6%: about 1.34 |
| D4 | `=POWER(27,1/3)` | 3 | A fractional power is a root: the cube root of 27 is 3 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  |  |
| 2 | Side (ft) | 12 |  | 144 |
| 3 | Annual growth | 6% |  | 1.338225578 |
| 4 | Years | 5 |  | 3 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Growth result is tiny | You raised the rate itself, as in POWER(6%,5). Add 1 first: =POWER(1+B3,B4). |
| #NUM! | A negative number raised to a fractional power, such as =POWER(-8,1/3), has no real result in Excel. Work with the absolute value and add the sign back. |
| Result is far too big | The percent was typed as a whole number (6 instead of 6% or 0.06). |

## Tips

- POWER(A2,B2) and A2^B2 are identical; use whichever reads better in your formula.

## Related functions

- [SQRT](https://spreadsheetpractice.com/functions/sqrt): SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.
- [EXP](https://spreadsheetpractice.com/functions/exp): EXP returns e (about 2.71828) raised to a power.
- [LOG](https://spreadsheetpractice.com/functions/log): LOG returns the logarithm of a number in the base you choose: the power the base must be raised to in order to reach the number.

## Questions

### Is POWER the same as the ^ operator?

Yes. =POWER(2,3) and =2^3 both return 8.

### How do I calculate compound interest in Excel?

Use =Principal*POWER(1+Rate,Years), for example =B2*POWER(1+C2,D2). FV does the same with regular deposits.

### How do I square a number in Excel?

Use =A2^2 or =POWER(A2,2).

## Practice

A graded POWER exercise ("Grow each deposit") is on [the POWER page](https://spreadsheetpractice.com/functions/power). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
