SQRT

The SQRT function returns the square root of a given number. It calculates the value that, when multiplied by itself, equals the input number. This function is commonly used in mathematical calculations, statistical analysis, and scientific computations involving area, distance, or variance.

Syntax

SQRT(value)

Arguments

• value: The number or node for which to return the square root.

Return value

Returns the square root of the specified number.

Example

SQRT(Sales)

In this example, the Sqrt of Sales measure is created using the SQRT function, which returns the square root of the values in Sales.

Excel equivalent

SQRT