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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | POWER(number, power)Or the operator: number ^ power. |
| Google Sheets | ✔ Built in | POWER(base, exponent)Or base ^ exponent. |
| Airtable | ✔ Built in | POWER(base, power) |
| Notion | ✔ Built in | pow(base, exponent)Or base ^ exponent. |
| Excel | =POWER(2, 10) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =POWER(2, 10) | open sheets.new ↗ |
| Airtable | POWER(2, 10) | |
| Notion | pow(2, 10) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The base. |
power | The exponent. Fractions give roots: 0.5 is a square root, 1/3 a cube root. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=POWER(2, 10) | 1024 | ||
=5^2 | 25 | The ^ operator does the same thing. | |
=POWER(27, 1/3) | 3 | Cube root. | |
=1000*POWER(1+5%, 10) | 1628.89 | Compound 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^2or=POWER(A2, 2). In Notion,pow(prop("x"), 2)orprop("x") ^ 2.