Returns a positive square root.

Syntax

Sqrt(number)

The Sqrt function syntax has the following arguments:

Number Required. The number for which you want the square root.

Remark

If number is negative, Sqrt returns the NaN (Not a Number) error value.

Examples

Formula

Description

Result

=Sqrt(16)

Square root of 16.

4

=Sqrt(-16)

Square root of -16. Because the number is negative, the NaN error message is returned.

NaN

=Sqrt(Abs(-16))

Avoiding the NaN error message by first using the Abs function to find the absolute value of -16 and then finding the square root.

4