POWER function
POWER raises a number to a power and returns the result. It does the same job as the ^ operator, and fractional powers take roots, so a power of one third gives a cube root.
Example
Read it as a sentence: raise 2 to the power of 10, which gives 1024.
A
B
C
D
1
1024
2
3
Syntax
POWER(number, power)
-
number(required) - The base.
-
power(required) - The exponent.
Returns: The base raised to the exponent.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=POWER(2,10) | 1024 | 2,10 |
=POWER(-8,1/3) | -2 | -8,1/3 |
=POWER(-8,3) | -512 | -8,3 |
=POWER(4,0.5) | 2 | 4,0.5 |
=POWER("2","3") | 8 | Text number |
=-8^(1/3) | -2 | ^ operator -8^(1/3) |
=POWER(0,0) | #NUM! | 0,0 |
=POWER(0,-1) | #DIV/0! | 0,-1 |
Watch out for
- Fractional powers take roots: POWER(27,1/3) is 3.
- Negative base with fractional power gives #NUM!.
Where it works
- Excel
- POWER is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .