Finding the Square Root of a Number
To get the SQUARE ROOT of a number in Excel, there are a variety of ways to do it. You can choose from the SQRT function or use the POWER function with the corresponding power argument (1/2).
For the SQRT function, the generic formula for SQUARE ROOT determination is given below:
=SQRT(cell containing the number or the number)
For the POWER function, the generic formula for SQUARE ROOT determination is given below:
=POWER(cell containing the number or the number, 1/2)
In example 1 below, the SQUARE ROOT of the number in Cell G7 is treated using the SQRT function while in example 2, the POWER function is used to determine the SQUARE ROOT of the number in Cell G8.
How to Find the Square Root of a Number
Input your data as shown in figure 1 below.
Click on Cell H7 as shown in figure 2 and type the content as shown on the figure into the cell.
Open a bracket and either highlight Cell G7 or type in the number as shown in figure 3. Close the bracket and press the ENTER button. You should have the result in figure 4.
Hence, the Basic formula, for example, one is =SQRT(H7). The SQRT function is one that gives the square root of a positive number in a cell.
Using the details we already have, we can skip step one. The next step is to highlight Cell H8 and type the POWER function as shown below.
Now, highlight Cell G8. Place a comma, leave a space and type ½. Close the bracket.
Hit the ENTER button and the result should be as shown in figure 7 below.