Documentation/Calc Functions/SQRT
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
SQRT
Category:
Mathematical
Summary:
Returns the positive square root of a number.
Syntax:
SQRT(Number)
Returns:
Returns a real non-negative number which is the positive square root of the Number. The resultant value is between 0 and ∞, i.e. [0,∞).
Arguments:
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.
Additional details:
The GIF below illustrates the SQRT function.
Examples:
Formula | Description | Returns |
---|---|---|
=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:
ODF standard:
Equivalent Excel function:
SQRT