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

Use the SQRT function to find the square root of a number.

Syntax

SQRT(number)

The SQRT function has the following arguments:

Argument Data type Description
number (required)

Number

The number you want to find the square root of. This must be a positive number, or zero.

Constraints

You can only find the square root of a positive number, or zero.

Examples

The following table shows some example formulas using the SQRT function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
SQRT(Rooms.Width)

This example shows how you can include line items or list properties in your formula. In this example, the value of Rooms.Width is 25.

5

SQRT(16)

The square root of 16.

4

SQRT(169.45)

The square root of 169.45.

13.0172961862

Excel equivalent

SQRT