SQRT

Formulas / SQRT
Calculate the positive square root of a number.
SQRT(number)
  • number - required, the number to get the square root of

Examples

  • =SQRT(9)

    The SQRT function is used in Sourcetable to calculate the square root of a number. For example, if you enter the formula in a cell, the result will be 3.

  • =SQRT(0.25)

    The SQRT function can also be used to calculate the square root of decimal numbers. For example, if you enter the formula into a cell, the result will be 0.5.

  • =SQRT(81)

    The SQRT function can also be used to calculate the square root of larger numbers. For example, if you enter the formula into a cell, the result will be 9.

  • =SQRT(144)

    The SQRT function can also be used to calculate the square root of even larger numbers. For example, if you enter the formula into a cell, the result will be 12.

Summary

The SQRT function is used to calculate the positive square root of a number. It requires one number argument to return the result.

  • The SQRT function requires one numeric argument and returns the square root of that argument.
  • If the argument is negative, the SQRT function will return a #NUM! error.


Frequently Asked Questions

What is the SQRT function?
The SQRT function is a math and trigonometry function that returns the square root of a positive number.
What is required as an argument for the SQRT function?
The SQRT function requires a positive number as its argument.
What types of numbers can be used for the SQRT function argument?
The number argument for the SQRT function must be a Sourcetable formula, a function that returns a positive number, or a positive number.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV