Sqrt
Returns a positive square root.
Syntax
Sqrt(number)
The Sqrt function syntax has the following arguments:
Number Required. The number for which you want the square root.
Remark
If number is negative, Sqrt returns the NaN (Not a Number) error value.
Examples
| Formula | Description | Result |
|---|---|---|
| =Sqrt(16) | Square root of 16. | 4 |
| =Sqrt(-16) | Square root of -16. Because the number is negative, the NaN error message is returned. | NaN |
| =Sqrt(Abs(-16)) | Avoiding the NaN error message by first using the Abs function to find the absolute value of -16 and then finding the square root. | 4 |
Updated almost 2 years ago