The SQRT function calculates the square root of a number.
SQRT
SQRT(Number)
Arguments
| Argument | Data type | Description |
| Number | Number | The number to calculate the square root of, or radicand. Must be a positive number or zero. |
The SQRT function returns a number.
Constraints
You can only use the SQRT function with a positive number or zero. If you use the SQRT function with a negative number, it returns a value of NaN (Not a Number).
Excel equivalent
Examples
| Formula | Result |
SQRT(16) | 4 |
SQRT(169.45) | 13.0172961862 |
SQRT(0) | 0 |
SQRT(-16) | NaN |
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.