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)

Get support
Contact us
Expand your Office skills
Explore training

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.

×