Documentation/Calc Functions/SQRT

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

Calc Functions Home | List of functions | Abbreviations

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