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)

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×