The POWER function raises a number to a specified power, equivalent to using the exponent operator (^). It returns the result of multiplying the number by itself as many times as the exponent indicates.
=POWER(number, power)What does POWER do?
The POWER function in Excel calculates a number raised to a given exponent. In plain terms, it multiplies a number by itself a certain number of times. For example, =POWER(5,2) returns 25 because 5 squared is 5 × 5. It is part of the Math & Trigonometry category and works in all modern versions of Excel.
POWER is useful whenever you need to apply exponential growth, calculate areas or volumes, or perform any mathematical operation involving exponents. Instead of writing =5*5*5, you can write =POWER(5,3) for clarity and flexibility, especially when the exponent is stored in another cell.
A common real-world scenario: a financial analyst projects compound interest. If an investment grows at 5% annually, the future value after 10 years is =POWER(1+5%,10) multiplied by the initial amount. POWER makes such formulas easy to read and adjust.
When to use POWER
- Calculating compound interest or investment growth over time.
- Determining the area of a square or volume of a cube from side length.
- Applying exponential smoothing or growth rates in forecasting.
- Converting between units that involve squared or cubed factors (e.g., square metres to square feet).
- Computing distances using the Pythagorean theorem.
- Scaling values in scientific or engineering calculations.
POWER syntax
=POWER(number, power)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The base number you want to raise. It can be any real number, a cell reference, or a formula. Example: =POWER(10,2) uses 10 as the base. |
power | Required | The exponent to which the base is raised. It can be positive, negative, or fractional. Example: =POWER(10,2) uses 2 as the exponent. |
What it returns: The result of raising the base number to the specified power. The return value is numeric.
POWER examples
1 Basic square and cube
This example shows how to calculate the square and cube of a number. The formula in D2 uses =POWER(B2,2) to square the value in B2. The result is 25, because 5 squared is 25. You can change the exponent to 3 to get the cube.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Number | Square | Cube | ||
| 2 | 5 | 25 | 125 | 25 | |
| 3 |
2 Compound interest calculation
Here we calculate the future value of an investment with compound interest. The formula in D2 is =POWER(1+B2,C2)*A2, which raises (1 + interest rate) to the number of years and multiplies by the principal. For a principal of 1000, rate 5%, and 10 years, the result is approximately 1628.89.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Principal | Rate | Years | ||
| 2 | 1000 | 0.05 | 10 | 1628.894627 | |
| 3 |
3 Area of a circle
This example computes the area of a circle given its radius. The formula in D2 is =PI()*POWER(B2,2), which squares the radius and multiplies by pi. For a radius of 3, the area is about 28.27.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Radius | Area | |||
| 2 | 3 | 28.27433388 | 2511.508411 | ||
| 3 |
4 Exponential growth projection
Project future population or sales using an exponential growth rate. The formula in D2 is =A2*POWER(1+B2,C2), where A2 is the initial value, B2 is the growth rate, and C2 is the number of periods. For an initial value of 500, growth rate 3%, and 5 periods, the result is approximately 579.64.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Initial | Growth Rate | Periods | ||
| 2 | 500 | 0.03 | 5 | 579.6370372 | |
| 3 |
Common POWER errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The number or power argument is non-numeric (e.g., text). | Ensure both arguments are numbers or valid cell references containing numbers. |
| #NUM! | The result is too large or too small for Excel to handle, or the base is negative and the exponent is fractional, producing a complex number. | Check the magnitude of the numbers and avoid negative bases with fractional exponents unless you intend to use complex functions. |
| #DIV/0! | The power argument is zero and the base is zero, which is mathematically undefined. | Avoid using zero for both arguments; ensure at least one is non-zero. |
Tips for using POWER
- Use the exponent operator
^as a shortcut:=5^2is equivalent to=POWER(5,2). - POWER can handle negative exponents:
=POWER(2,-3)returns 0.125. - For square roots, use
=POWER(number,0.5)or=SQRT(number). - Combine POWER with other functions like
SUMorAVERAGEfor advanced calculations. - Remember that Excel evaluates
-2^2as(-2)^2= 4, but=-2^2as-(2^2)= -4; use parentheses to avoid confusion.
Frequently asked questions
What is the difference between POWER and the ^ operator?
They are functionally identical. =POWER(2,3) and =2^3 both return 8. The ^ operator is shorter, but POWER can be clearer in complex formulas.
Can POWER return a negative result?
Yes, if the base is negative and the exponent is an odd integer. For example, =POWER(-2,3) returns -8. If the exponent is even, the result is positive.
How do I calculate the nth root using POWER?
Use a fractional exponent: the nth root of a number is =POWER(number,1/n). For example, the cube root of 27 is =POWER(27,1/3) which returns 3.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. POWER reference