Documentation/Calc Functions/SQRT

    From The Document Foundation Wiki
    Other languages:


    Function name:

    SQRT

    Category:

    Mathematical

    Summary:

    Calculates the positive square root of a non-negative real number.

    Syntax:

    SQRT(Number)

    Returns:

    Returns a non-negative real number that is the positive square root of the given number.

    Arguments:

    Number is a non-negative real number, or a reference to a cell containing that number, whose square root is to be taken.

    • If Number is non-numeric, then SQRT reports a #VALUE! error.
    • If Number is negative, then SQRT reports an invalid argument error (Err:502).

    Additional details:

    The figure below illustrates the SQRT function.

    SQRT function

    Examples:

    Formula Description Returns
    =SQRT(16) Here the function returns the positive square root of 16. 4
    =SQRT(D1) where cell D1 contains the number 36.78. Here the function returns the positive square root of 36.78. 6.06465168002252

    Related LibreOffice functions:

    IMSQRT

    POWER

    SQRTPI

    ODF standard:

    Section 6.16.58, part 2

    Related (or similar) Excel functions:

    SQRT