Spreadsheet Practice

SQRT function

Quick answer

SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.

Syntax
=SQRT(number)
Most common use
=SQRT(B2) returns 14 (Side of a 196 sq ft square room: 14 ft)

It shows up in geometry (side lengths, distances) and statistics, where a standard deviation is the square root of a variance.

Available in
Every current version
Category
Math functions
Returns
The positive square root.
Google Sheets
Works the same in Google Sheets.

Syntax

=SQRT(number)

ArgumentRequired?What it is
numberRequiredThe number to take the square root of. It can't be negative.

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=SQRT(B2)14Side of a 196 sq ft square room: 14 ft
D3=SQRT(B3)48Standard deviation from a variance: 48
D4=SQRT(B4)#NUM!#NUM!: negative numbers have no real square root

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
MeasureValueSquare root
Square room (sq ft)19614
Variance of daily sales230448
Negative input-16#NUM!

Practice SQRT

Graded instantly, then re-checked on changed data.

Straight-line distance

Each route has an east-west and a north-south distance. In D2, use SQRT to find the straight-line distance (the square root of each distance squared, added together). Fill down to D6.

Common mistakes

What you seeWhy, and how to fix it
#NUM!The number is negative. If only the size matters, use =SQRT(ABS(A2)).
Needed a cube rootSQRT only does square roots. Use a fractional power instead: =A2^(1/3).
#VALUE!The cell holds text. Check for numbers stored as text.

Tips

  • Straight-line distance between two points: =SQRT((x2-x1)^2+(y2-y1)^2).

Questions

How do I calculate a square root in Excel?

Use =SQRT(A2), or =A2^0.5, which does the same.

How do I calculate a cube root in Excel?

Use =A2^(1/3) or =POWER(A2,1/3).

Why does SQRT return #NUM!?

The number is negative. Square roots of negative numbers aren't real numbers.

Answers that use SQRT

In other languages

SQRT is RAIZ in Spanish Excel and WURZEL 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 .