Get instant live expert help with Excel or Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# Excel SQRT Function

We use Excel SQRT function when we want to get the square root of a positive number. The SQRT function will return an error if supplied with a negative number. To fully understand how this function works, read this step-by-step guide on how to use the Excel SQRT function.

Figure 1: Use of SQRT function

## Syntax of the formula

`=SQRT(number)`

Where number refers to the number of which you want to get the square root of.

The function only works with positive numbers, and will return a positive result. It will return a #NUM! error if applied on a negative number, as shown in the example above.

But you can still get the square root of a negative number by wrapping the number in the ABS function.

## Example: Finding square root of negative number

Figure 2: Square root of negative numbers

Notice that the numbers in column A are all negative numbers. We have wrapped the numbers in an ABS function to get the square root of the negative numbers. The formula in cell B2 in the example above looks like below:

`=SQRT(ABS(A2))`

We then copy down the formula to apply it to all the other cells.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchatservice! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

### Did this post not answer your question? Get a solution from connecting with the expert. 