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)

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×