Quick Answer
POWER Function
POWER calculates number^power, raising a base number to an exponent.
✓ Excel✓ Google SheetsExcel All versions
Syntax
POWER
(number, power)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The base number to raise to a power. | Required |
| power | The exponent to raise the base to. | Required |
Basic Example
Calculate 2 to the power of 3
=POWER(2, 3)Result8
Returns 2 raised to the power of 3, which equals 8.
Advanced Examples
Example 1: Calculate compound interest
FinanceCompute future value with compound interest
=POWER(1+A1, B1)*C1Result: $1,628.89
Calculates future value using the formula PV*(1+r)^n.
Example 2: Calculate nth root
MathematicsFind the cube root of a number
=POWER(27, 1/3)Result: 3
Raises 27 to the 1/3 power to get the cube root.
How POWER Works
POWER computes number^power by multiplying the base number by itself power times.
1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =POWER(base, exponent).
3
Press Enter
The result shows the calculated power.
Important Notes & Limitations
Negative numbers raised to non-integer powers return #NUM!.
For roots, use fractional exponents like 1/2 for square root.
Common Errors & Fixes
#NUM!Negative number raised to non-integer powerFix: Use ABS for negative bases or use integer exponents.
Download Practice File
POWER
powerPractice POWER with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the POWER function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Frequently Asked Questions
Is POWER the same as the ^ operator?
Yes, =POWER(2, 3) is equivalent to =2^3.
Can I use decimal exponents?
Yes, POWER(10, 0.5) calculates the square root of 10.