How do you calculate a square root of a number in Excel?

Answer 1

You calculate square root in Excel using the Sqrt() function.

for example:

If the value of A1 is 81

and A2 contained the formula "=Sqrt(A1)",

The number 9 would be displayed.

Answer 2

You can multiply the number by itself or by the power of 2. In Excel, you have an operator to do it and also a function. To find the square of 34, you could do it in any of these ways:

=34*34

=34^2

=POWER(34,2)

You would normally use a cell reference instead of the actual value, so if the 34 was in cell A2 then the above formulas would become:

=A2*A2

=A2^2

=POWER(A2,2)

Answer 3

You can multiply a number by itself or multiply by the power of 2. That can be done with an operator or with a function. So there are several ways of doing it. Assuming the value was in cell A3, here are those 3 ways of doing it.

=A3*A3

=A3^2

=POWER(A3,2)

Answer 4

Use the SQRT function.

Example:

=SQRT(A1)

Answer 5

=SQRT(number)