Quick, clean, and to the point

Excel SQRT Function

Excel SQRT function

The Excel SQRT function returns the square root of a positive number. SQRT returns an error if number is negative.

Find the positive square root of a number
Return value 
Positive square root
=SQRT (number)
  • number - The number to get the square root of.
Usage notes 

The SQRT function will return a #NUM error when asked to take the square root of a negative number. If you need to get the square root of a negative value (as if the value was positive) you can wrap the number in the ABS function like this:


Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.