The SQRT function

Returns the square root of a number. A negative number gives

Syntax

SQRT(number)
number
The number to take the square root of. It must be 0 or more.

Examples

B1=SQRT(144)
AB
112
D1=SQRT(B1^2+B2^2)
ABCD
1Width35
2Height4
B1=SQRT(ABS(-16))
AB
14

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.

Related functions