SQRT

Try it

When to use it

When should I use SQRT instead of POWER?

Use SQRT for the square root of a single value; it reads more clearly than POWER(x, 0.5). Use POWER when you need other roots or exponents.

What happens if I pass a negative number to SQRT?

SQRT returns the #NUM! error for negative inputs because there is no real square root. Wrap the argument with ABS first if you only care about magnitude.

Use cases

Irrational root used in geometry

Hypotenuse length from two legs

Used in

science · engineering

Syntax

SQRT(number)

Examples

=SQRT(9) // => 3