Returns the positive square root of a number.
Returns a real non-negative number which is the positive square root of (PI multiplied by Number). The resultant value is between 0 and ∞, i.e. [0,∞).
Number is a non-negative real number or a reference to the cell containing that number whose square root is to be taken.
If the Number is negative, the function returns an error value.
The GIF below illustrates the SQRT function.
|=SQRT(16)||positive square root of 16||4|
|=SQRT(-16)||positive square root is not defined for negative number so the function returns an error value||Err:502|
Related LibreOffice functions:
Equivalent Excel function: