The SQRT function returns the positive square root of a given number. It is a simple mathematical tool for finding what value multiplied by itself equals the input number.
=SQRT(number)What does SQRT do?
The SQRT function in Excel calculates the square root of a number. You provide a non-negative number, and it returns the value that, when multiplied by itself, equals that number. For example, =SQRT(25) returns 5 because 5 × 5 = 25. It is part of Excel's Math & Trigonometry functions and works in every modern version of Excel.
Square roots appear in many everyday tasks: calculating standard deviations, determining the length of a side in geometry, adjusting financial formulas, or normalising data. Instead of manually finding square roots or using a calculator, you can embed SQRT directly in your spreadsheets so results update automatically when data changes.
Imagine you work in quality control and need to compute the standard deviation of product weights. The formula for standard deviation involves taking the square root of the variance. With SQRT, you can reference the variance cell and get the standard deviation instantly, saving time and reducing errors.
When to use SQRT
- Calculating the side length of a square when the area is known.
- Finding standard deviation from variance in statistical analysis.
- Determining the distance between two points using the Pythagorean theorem.
- Normalising data by taking the square root of values in data science.
- Computing compound annual growth rates or other financial metrics that involve roots.
- Solving engineering problems that require square roots, such as stress or signal calculations.
SQRT syntax
=SQRT(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The number for which you want the square root. It must be a non-negative numeric value, a cell reference containing a number, or a formula that returns a number. For example, =SQRT(16) returns 4, and =SQRT(A2) returns the square root of the value in cell A2. |
What it returns: The positive square root of the input number. If the number is negative, SQRT returns the #NUM! error. If the number is non-numeric, it returns the #VALUE! error.
SQRT examples
1 Basic square root of a single number
This example shows the simplest use of SQRT with a number typed directly into the formula. The goal is to find the square root of 144. The formula =SQRT(144) calculates the value that, when multiplied by itself, equals 144. It returns 12, because 12 × 12 = 144.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Number | Square Root | ||
| 2 | 144 | 12 | ||
| 3 |
2 Square root of a value in a cell
Here you reference a cell that contains the number. The goal is to calculate the square root of the area in cell A2. The formula =SQRT(A2) takes the value from A2 (which is 256) and returns its square root. The result is 16, since 16 × 16 = 256.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Area | Side Length | ||
| 2 | 256 | 16 | ||
| 3 |
3 Square root of a calculated value
This example uses SQRT with an expression. The goal is to find the square root of the sum of two numbers. The formula =SQRT(A2+B2) first adds the values in A2 and B2 (9 + 16 = 25), then returns the square root of 25. The result is 5.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Value 1 | Value 2 | ||
| 2 | 9 | 16 | 5 | |
| 3 |
4 Square root in a geometry context
Suppose you know the area of a square and need its side length. The goal is to find the side length for each square in the table. The formula =SQRT(B2) takes the area from B2 and returns the side length. For an area of 49, the side length is 7.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Square | Area | ||
| 2 | Square 1 | 49 | 7 | |
| 3 | Square 2 | 81 | ||
| 4 | Square 3 | 100 | ||
| 5 |
5 Square root for standard deviation from variance
In statistics, standard deviation is the square root of variance. The goal is to compute the standard deviation for each dataset. The formula =SQRT(B2) takes the variance in B2 and returns the standard deviation. For a variance of 25, the standard deviation is 5.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Dataset | Variance | ||
| 2 | Dataset A | 25 | 5 | |
| 3 | Dataset B | 36 | ||
| 4 | Dataset C | 49 | ||
| 5 |
Common SQRT errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #NUM! | The number argument is negative. Square roots of negative numbers are not real numbers in Excel. | Ensure the number is zero or positive. If you need to handle negative numbers, use =SQRT(ABS(number)) or check your data. |
| #VALUE! | The number argument is non-numeric, such as text or a blank cell that is interpreted as text. | Verify that the cell contains a number. Use ISNUMBER to test, or convert text to numbers. |
| #NAME? | The function name is misspelled, for example =SQRT without the closing parenthesis or =SQRTT. | Check the spelling: it should be SQRT followed by parentheses. |
| Wrong result due to cell reference | The formula references an empty cell or a cell with an unexpected value. | Double-check the cell reference and ensure it points to the intended number. |
Tips for using SQRT
- Use SQRT with ABS to avoid #NUM! errors when you are unsure if values might be negative:
=SQRT(ABS(A2)). - Combine SQRT with other functions like SUM or AVERAGE to calculate roots of aggregated data.
- Remember that SQRT returns only the positive root; if you need both roots, calculate the negative separately.
- For cube roots or other roots, use the exponent operator:
=A2^(1/3)for cube root. - Format the result cell to show decimals if needed; SQRT returns a full-precision number.
Frequently asked questions
Can SQRT handle negative numbers?
No, SQRT returns #NUM! for negative numbers because the square root of a negative number is not a real number. Use ABS to get the root of the absolute value if appropriate.
What is the difference between SQRT and the exponent operator?
SQRT(A2) is equivalent to A2^(1/2). Both return the square root, but SQRT is clearer and slightly faster to type.
Does SQRT work with arrays?
Yes, in modern Excel with dynamic arrays, SQRT can accept an array and return an array of square roots. In older versions, you may need to enter it as an array formula.
How do I calculate the square root of a percentage?
Percentages are stored as decimals, so SQRT(0.25) returns 0.5, which is 50%. Format the result as a percentage if needed.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. SQRT reference