Syntax
SQRT(number)- number
- The number to take the square root of. It must be 0 or more.
Examples
B1=SQRT(144)
| A | B | |
|---|---|---|
| 1 | 12 |
D1=SQRT(B1^2+B2^2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Width | 3 | 5 | |
| 2 | Height | 4 |
B1=SQRT(ABS(-16))
| A | B | |
|---|---|---|
| 1 | 4 |
Questions
Why does SQRT return
The number is negative. If you only want the root of its size, write =SQRT(ABS(A2)).
How do I calculate a cube root in Excel?
Raise the number to the power of 1/3, as in =A2^(1/3) or =POWER(A2,1/3). SQRT only does square roots.