The Excel SQRT Function

Related Function:
POWER function

Function Description

The Excel Sqrt function calculates the positive square root of a supplied number.

The syntax of the function is:

SQRT( number )

where the number argument is the numeric value that you want to find the square root of.

If the supplied number is negative, the Sqrt function returns the #NUM! error.


Excel Sqrt Function Examples

The following spreadsheet shows three simple examples of the Excel Sqrt function.

 Formulas:
 AB
1 =SQRT( 25 )
215625=SQRT( A2 )
36.5536=SQRT( A3 )
 Results:
 AB
1 5
215625125
36.55362.56

For further examples of the Excel Sqrt function, see the Microsoft Office website.


Sqrt Function Errors

If you get an error from the Excel Sqrt Function, this is likely to be one of the following:

Common Errors
#NUM!-Occurs if the supplied number is negative.
#VALUE!-Occurs if the supplied number is non-numeric.