< Go Back

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.

Example

Below is some of the example of using this formula

 

 

Figure 1 – Excel SQRT Function

Explanation

The formula in B3

=SQRT(A3)

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:

=SQRT(ABS(A7))

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
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar