Check Sheet Logo
Check Sheet

SQRT

The SQRT function returns the positive square root of a given number. It can be used to find the length of a side of a right triangle, or to calculate standard deviation. The function takes one argument, the value or reference to the cell containing the number for which you want to find the square root.

Usage

Use the SQRT formula with the syntax shown below, it has 1 required parameter:

=SQRT(value)
Parameters:
  1. value (required):
    The number for which you want to find the square root. Must be a positive number or a reference to a cell containing a positive number.

Examples

Here are a few example use cases that explain how to use the SQRT formula in Google Sheets.

Finding the length of a side of a right triangle

If you know the lengths of two sides of a right triangle, you can use the Pythagorean theorem to find the length of the third side. For example, if side A is 3 and side B is 4, you can use the formula =SQRT(A2^2 + B2^2) to find the length of side C (which will be 5).

Calculating standard deviation

The SQRT function can be used as part of a formula to calculate the standard deviation of a range of values. For example, if your values are in cells A1 to A10, you can use the formula =SQRT(SUMSQ(A1:A10) / COUNT(A1:A10) - AVERAGE(A1:A10)^2) to calculate the standard deviation.

Common Mistakes

SQRT not working? Here are some common mistakes people make when using the SQRT Google Sheets Formula:

Using a negative value

The value provided to the SQRT function must be a positive number. If a negative number is used, a #NUM! error will occur. To correct this, ensure that the value being used is positive.

Incorrect number of arguments

The SQRT function requires exactly one argument to be provided. If more or less than one argument is provided, a #VALUE! error will occur. To correct this, ensure that only one argument is provided.

Using a non-numeric value

The value provided to the SQRT function must be a numeric value. If a non-numeric value is used, a #VALUE! error will occur. To correct this, ensure that the value being used is a numeric value.

The following functions are similar to SQRT or are often used with it in a formula:

  • POW

    The POW formula is a mathematical operator in Google Sheets used to raise a base number to the power of an exponent. It returns the result of the calculation. This formula is commonly used in financial analysis, engineering, and scientific research.

  • SUMSQ

    The SUMSQ formula is a Math formula that returns the sum of the squares of a given set of numbers. It is commonly used to calculate the sum of squares for a set of values, which can be useful in statistical analysis and other mathematical operations.

  • PRODUCT

    The PRODUCT formula in Google Sheets multiplies all the numbers given in the arguments and returns the product. It is commonly used to calculate the total product of a range of cells.

  • AVERAGE

    The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

  • LN

    The LN formula returns the natural logarithm of a given value. The natural logarithm is the logarithm to the base e, where e is an irrational number approximately equal to 2.71828. The formula is commonly used in mathematical and scientific calculations.

Learn More

You can learn more about the SQRT Google Sheets function on Google Support.