Documentation/Calc Functions/SQRT

Other languages:

SQRT

Mathematical

Summary:

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

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).

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

SQRT