Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The SQRT function 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 the number is negative, SQRT returns the #NUM! error value.
Example
| Formula | Description | Result |
|---|---|---|
| =SQRT(16) | Square root of 16. | 4 |
| =SQRT(-16) | Square root of -16. Because the number is negative, the #NUM! error message is returned. | #NUM! |
| =SQRT(ABS(-16)) | Avoiding the #NUM! error message by first using the ABS function to find the absolute value of -16 and then finding the square root. | 4 |
Errors
For a full list of formula errors, please read Formula errors.