Jump to content

Documentation/Calc Functions/SQRT

From The Document Foundation Wiki


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