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
Positive square root
number - The number to get the square root of.
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:
To get the square root of a number, you can use the SQRT function. In the example shown, the formula in C5 is:
How this function works
The SQRT function is fully automatic and will return the square root...