< Go Back

Square root of number

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

Example 1

Step 1

Input your data as shown in figure 1 below.

Step 2

Click on Cell H7 as shown in figure 2 and type the content as shown on the figure into the cell.

Step 3

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.  

Example 2

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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar