SQRT function

Returns a positive square root.

Syntax

SQRT(number)

Number     is the number for which you want the square root.

Remark

If number is negative, SQRT returns the #NUM! error value.

Examples

Formula

Description (Result)

=SQRT(16)

Square root of 16 (4)

=SQRT(-16)

Square root of 16. Because the number is negative, an error is returned (#NUM!)

=SQRT(ABS(-16))

Square root of the absolute value of the number (4)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×