Syntax. SQRT(number)

Definition. This function returns the square root of a number.

Argument

Background. The root function is an inverse function to the exponentiation.

Base (b) is the radicand, and x is the order of a root. If the order of a root is 2, it is called a square root.

The SQRT() function returns only the square root of a positive number. If number is negative, the function returns the #NUM! error.

Example. A building lot has the dimensions 19.5 x 10.5 m. You want to know the dimensions of a coextensive square building lot.

The formula

=SQRT(19.5 • 10.5)

as well as the formula

=SQRT(PRODUCT(19.5;10.5))

return 14.309088. To round the result to two decimal places, you use the ROUND() function:

=ROUND((SQRT(PRODUCT(19.5,10.5))),2)

The formula breaks down as follows:

The result is 14.31 m.