Returns the positive square root of a positive number.
Sample usage
SQRT(9)
SQRT(A2)
Syntax
SQRT(value)
-
value
– The number for which to calculate the positive square root.value
must be positive; if it is negative, SQRT will return the #NUM! error.
Notes
-
To find the negative root of
value
, simply multiply the result of the SQRT function call by -1.
See also
SQRTPI
: Returns the positive square root of the product of Pi and the given positive number.
POWER
: Returns a number raised to a power.
LOG10
: Returns the logarithm of a number, base 10.
LOG
: Returns the logarithm of a number given a base.
LN
: Returns the logarithm of a number, base e (Euler's number).
GAMMALN
: Returns the logarithm of a specified gamma function, base e (Euler's number).
EXP
: Returns Euler's number, e (~2.718) raised to a power.