Spreadsheet formulas explained, side by side

POWER Function in Excel, Google Sheets, Airtable & Notion

POWER(base, exponent) raises a number to a power. POWER(2, 10) is 1024 — the same as typing 2^10.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inPOWER(number, power)
Or the operator: number ^ power.
Google Sheets✔ Built inPOWER(base, exponent)
Or base ^ exponent.
Airtable✔ Built inPOWER(base, power)
Notion✔ Built inpow(base, exponent)
Or base ^ exponent.
Try POWER with your own values
Result (as Excel & Google Sheets return it)
1,024
Your formula, ready to paste
Excel=POWER(2, 10) open excel.new ↗
Google Sheets=POWER(2, 10) open sheets.new ↗
AirtablePOWER(2, 10)
Notionpow(2, 10)

Arguments

ArgumentWhat it means
numberThe base.
powerThe exponent. Fractions give roots: 0.5 is a square root, 1/3 a cube root.

Examples

FormulaResultWhyCopy
=POWER(2, 10)1024
=5^225The ^ operator does the same thing.
=POWER(27, 1/3)3Cube root.
=1000*POWER(1+5%, 10)1628.89Compound growth: $1,000 at 5% for 10 years.

Examples use Excel / Google Sheets syntax unless noted.

How POWER works

POWER and the ^ operator are interchangeable; most people type ^ for short formulas and POWER when the exponent is itself a long expression. Fractional exponents give roots, so =POWER(A2, 1/3) is a cube root and =A2^0.5 equals SQRT(A2).

Watch operator precedence with negative numbers: in Excel and Google Sheets, =-2^2 is 4 because the minus sign is applied first. Write =-(2^2) or =0-2^2 for −4. A negative base with a fractional exponent such as POWER(-8, 1/3) returns #NUM! because there is no real result in the general case.

Frequently Asked Questions

How do I square a number in a spreadsheet?
Use =A2^2 or =POWER(A2, 2). In Notion, pow(prop("x"), 2) or prop("x") ^ 2.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.