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.
Can I take a square root without SQRT?
Yes. Raise the number to the power of one half, as in =A2^0.5 or =A2^(1/2). It gives the same result as =SQRT(A2).
How do I insert a square root symbol in Excel?
Choose Insert, Symbol, and find the √ character. The symbol is only text, so for the calculation itself you still use SQRT or ^0.5.