Returns a positive square root.
Syntax
SQRT(number)
Number is the number for which you want the square root.
Remark
If number is negative, SQRT returns the #NUM! error value.
Examples
Formula |
Description (Result) |
=SQRT(16) |
Square root of 16 (4) |
=SQRT(-16) |
Square root of 16. Because the number is negative, an error is returned (#NUM!) |
=SQRT(ABS(-16)) |
Square root of the absolute value of the number (4) |