FormulaCraft

SQRT

SQRT returns the principal square root of a non-negative number. For other roots, raise the number to a fractional power with POWER or ^.

Excel
=SQRT(A2)
Google Sheets
=SQRT(A2)
✓

Verified example

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

Value
81

=SQRT(A2)→9

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 holds the number.
  2. 2SQRT returns its square root.
  3. 381 returns 9.

Need a version for your data?

Try: “Get the square root of the number in A2”

Related

SUMIFSUMIFSCOUNTIF

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

Last reviewed: