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)

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×