SQRT returns an error ifnumberis negative.

The SQRT function takes one argument,number, which must be a numeric value.

Ifnumberis not numeric, SQRT returns a #VALUE!

Excel formula: Square root of number

Ifnumberis negative, SQRT returns a #NUM!

Examples

Negative numbers

The SQRT function will return a #NUM!

The POWER function is an alternative to theexponent operator(^).

Excel formula: Distance formula

Excel POWER function