SQRT

Using the Excel SQRT Function

Summary

The Excel SQRT function returns the positive square root of a number.

Syntax

=SQRT (number)

Syntax Breakdown

number
The number argument is required in the SQRT function and is the number for which you would like to find the square root.


Usage Notes

The SQRT function returns the positive square root of a number. If the number argument is negative, the function returns the #NUM! error. If you must find the square root of a negative number you can wrap the number argument in the ABS function. For example, =SQRT(ABS(A1)) assuming cell A1 contains the negative number for which you want to find the square root.

Excel SQRT NUM Error