Spreadsheet Practice

POWER function

Quick answer

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)

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.

Available in
Every current version
Category
Math functions
Returns
number raised to power.
Google Sheets
Works the same in Google Sheets.

Syntax

=POWER(number, power)

ArgumentRequired?What it is
numberRequiredThe base number.
powerRequiredThe exponent to raise it to. Fractions give roots: 1/2 is a square root.

Examples

Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.

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

Try it live

This is the sample sheet. Change any number or text, or edit a formula, and the results update.

Show the sample data as a table
InputValue
Side (ft)12144
Annual growth6%1.338225578
Years53

Practice POWER

Graded instantly, then re-checked on changed data.

Grow each deposit

In E2, use POWER to find what each deposit is worth after compounding once a year: deposit × (1 + rate) to the power of years. Fill down to E6.

Common mistakes

What you seeWhy, and how to fix it
Growth result is tinyYou 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 bigThe 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.

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).

Answers that use POWER

In other languages

POWER is POTENCIA in Spanish Excel and POTENZ in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.

Updated Checked by running: every formula on this page was run by our formula engine on .