SQRT function

Returns a positive square root.



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


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



Description (Result)


Square root of 16 (4)


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


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

Need more help?

Expand your Office 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.