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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | SQRT(number) |
| Google Sheets | ✔ Built in | SQRT(value) |
| Airtable | ✔ Built in | SQRT(value) |
| Notion | ✔ Built in | sqrt(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 ↗ |
| Airtable | SQRT(144) | |
| Notion | sqrt(144) |
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 | A number zero or greater. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=SQRT(144) | 12 | ||
=SQRT(-9) | #NUM! | No real root. | |
=SQRT(B2^2 + C2^2) | Hypotenuse | Pythagoras: 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 hascbrt().