How to get the square root in Excel?

The square root is the result of multiplying a positive number by itself. In Excel it is easy to enter your formula, but you need to know the program and its tools.

Therefore, in this article we will teach you how to how to put a square root in Excel in an easy and simple way. In this way, you will systematize different calculations and speed up the processes.

Using a formula

To calculate the square root in Excel using the formula, you just have to do the following steps:

1. Enter the number for which you wish to perform the calculation. In an empty cell write “=ROOT(”.
2. Now, click on the box containing the number. You will see that a cell reference will be created. In this case it is “A2”.
3. Close parentheses and press “Enter”. This way you will be able to see the result.

Manually

If you want to calculate the square root in Excel manually, you must execute the following:

1. In a separate cell, write the number to which you want to take the square root.
2. In an available cell enter the equals symbol (=), click on the cell that has the number and insert the symbol circumflex accent (^) and in parentheses write 1/2.
3. Press “Enter” and observe the result.

Note: You can also do this process if you want to know the cube root of a number, but you must write 1/3 in parentheses.

Observations

If you you calculate the square root of a negative number, the formula will throw the error “#NUM!” or “#VALUE!” To solve it, you just have to add ABS function (absolute value). In this way, first the absolute value of the number will be calculated and after that, its square root will be calculated.

As you have seen, you have two processes to calculate or insert a square root in Excel. You just have to choose the method that is simplest and most practical for your calculations.