SQRT
The SQRT function returns the square root of a number.
This can be useful in various mathematical and statistical calculations.
Syntax
SQRT(value)
| Argument | Description | Permitted values |
|---|---|---|
| value | Number for which the square root needs to be calculated | Positive number or a reference to a cell containing a number |
Examples of use
Calculating the square root of a number
=SQRT(16)
This formula will return 4, since the square root of 16 is 4.
Use with reference to cell
=SQRT(A1)
If cell A1 contains the number 25, the formula will return 5, since the square root of 25 is 5.
Application in more complex calculations
=SQRT(SUM(A1:A5))
This formula will first calculate the sum of the values in the range A1:A5, and then extract the square root from the result.
Notes
If the argument is a negative number, the SQRT function will return the #NUM! error, since the square root of a negative number is undefined in real numbers.