FormulaCraft

POWER

POWER raises a base to an exponent — POWER(7,2) is 7 squared. It is interchangeable with the ^ operator but reads more clearly in long formulas.

Excel
=POWER(A2, 2)
Google Sheets
=POWER(A2, 2)

Verified example

Computed by a real spreadsheet engine on the sample data below.

Value
7

=POWER(A2, 2)49

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the base number.
  2. 22 is the exponent (squared).
  3. 37 squared is 49.

Need a version for your data?

Try: “Square the number in A2

Related

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: