Spreadsheet formulas explained, side by side

SQRT Function in Excel, Google Sheets, Airtable & Notion

SQRT returns the positive square root of a number. SQRT(144) is 12. Negative numbers return #NUM!.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inSQRT(number)
Google Sheets✔ Built inSQRT(value)
Airtable✔ Built inSQRT(value)
Notion✔ Built insqrt(number)
Try SQRT with your own values
Result (as Excel & Google Sheets return it)
12
Your formula, ready to paste
Excel=SQRT(144) open excel.new ↗
Google Sheets=SQRT(144) open sheets.new ↗
AirtableSQRT(144)
Notionsqrt(144)

Arguments

ArgumentWhat it means
numberA number zero or greater.

Examples

FormulaResultWhyCopy
=SQRT(144)12
=SQRT(-9)#NUM!No real root.
=SQRT(B2^2 + C2^2)HypotenusePythagoras: distance from two sides.

Examples use Excel / Google Sheets syntax unless noted.

How SQRT works

SQRT is the same as raising a number to the power 0.5. It appears in distance calculations, in standard deviation and in converting an area back into a side length. For other roots use POWER with a fractional exponent: =POWER(A2, 1/3) for a cube root.

Negative input is the only failure case. Excel and Sheets return #NUM!; Airtable returns NaN; Notion returns an empty / NaN result. Guard with IF(A2 < 0, "", SQRT(A2)) when negatives are possible.

Frequently Asked Questions

How do I calculate a cube root?
Use =A2^(1/3) or =POWER(A2, 1/3). Notion also has cbrt().

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.