Excel SQRT function returns a square root of a positive numeric value.
number – The number to get the square root of. It should be a positive number.
Below is some of the example of using this formula
Figure 1 – Excel SQRT Function
The formula in B3
The result is 3
The formula in B7 returns #NUM! error as the value in A7 is negative.
If you want to use SQRT in this case, you need to use a formula:
Excel ABS function returns the absolute value of a number.