SQRT

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.

Examples