# SQRT function in Excel

> SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.

Source: https://spreadsheetpractice.com/functions/sqrt · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** SQRT returns the square root of a number: the value that, multiplied by itself, gives the number.
- **Syntax:** `=SQRT(number)`
- **Most common use:** `=SQRT(B2)` returns 14 (Side of a 196 sq ft square room: 14 ft)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The positive square root.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

SQRT returns the square root of a number: the value that, multiplied by itself, gives the number. It shows up in geometry (side lengths, distances) and statistics, where a standard deviation is the square root of a variance.

## Syntax

`=SQRT(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number to take the square root of. It can't be negative. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=SQRT(B2)` | 14 | Side of a 196 sq ft square room: 14 ft |
| D3 | `=SQRT(B3)` | 48 | Standard deviation from a variance: 48 |
| D4 | `=SQRT(B4)` | #NUM! | #NUM!: negative numbers have no real square root |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Measure | Value |  | Square root |
| 2 | Square room (sq ft) | 196 |  | 14 |
| 3 | Variance of daily sales | 2304 |  | 48 |
| 4 | Negative input | -16 |  | #NUM! |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | The number is negative. If only the size matters, use =SQRT(ABS(A2)). |
| Needed a cube root | SQRT only does square roots. Use a fractional power instead: =A2^(1/3). |
| #VALUE! | The cell holds text. Check for numbers stored as text. |

## Tips

- Straight-line distance between two points: =SQRT((x2-x1)^2+(y2-y1)^2).

## Related functions

- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.
- [ABS](https://spreadsheetpractice.com/functions/abs): ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250.
- [SUMSQ](https://spreadsheetpractice.com/functions/sumsq): SUMSQ squares each number and adds the squares.

## Questions

### How do I calculate a square root in Excel?

Use =SQRT(A2), or =A2^0.5, which does the same.

### How do I calculate a cube root in Excel?

Use =A2^(1/3) or =POWER(A2,1/3).

### Why does SQRT return #NUM!?

The number is negative. Square roots of negative numbers aren't real numbers.

## Practice

A graded SQRT exercise ("Straight-line distance") is on [the SQRT page](https://spreadsheetpractice.com/functions/sqrt). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
