The SQRT function calculates the square root of a number.

SQRT(Number)

ArgumentData typeDescription
NumberNumber

The number to calculate the square root of, or radicand.

Must be a positive number or zero.

The SQRT function returns a number.

You can only use the SQRT function with a positive number or zero. If you use the SQRT function with a negative number, it returns a value of NaN (Not a Number).

SQRT

FormulaResult
SQRT(16)4
SQRT(169.45)13.0172961862
SQRT(0)0
SQRT(-16)NaN