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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
770356897247836772
true
Search Help Center
true
true
true
true
true
35
false
false