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.

## Leave a Comment