1. Calculation functions
  2. All Functions
  3. Numeric functions
  4. SQRT

The SQRT function calculates the square root of a number.

Syntax

SQRT(Number)

Arguments

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.

Constraints

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).

Excel equivalent

SQRT

Examples

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