SQRT function
SQRT returns the positive square root of a number, for example to find a side length from an area. A negative number returns #NUM!. For other roots, use POWER.
Example
Read it as a sentence: find the square root of 144, which gives 12.
A
B
C
D
1
12
2
3
Syntax
SQRT(number)
-
number(required) - A number zero or higher.
Returns: The positive square root.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SQRT(0.5) | 0.707106781 | Positive |
=SQRT(0) | 0 | Zero |
=SQRT(2) | 1.414213562 | Larger value |
=SQRT("0.5") | 0.707106781 | Text number "0.5" |
=SQRT(TRUE) | 1 | TRUE |
=SQRT({0.1,0.2}) | 0.316227766 | Array constant spills |
=SQRT(-0.5) | #NUM! | Negative |
=SQRT("abc") | #VALUE! | Non-numeric text |
Watch out for
- Negative numbers return #NUM!.
- For other roots use POWER(x,1/n).
Where it works
- Excel
- SQRT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .