Excel SQRT Function

Excel SQRT function returns a square root of a positive numeric value.

Generic Formula

= SQRT(number)

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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment