**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.

## Leave a Comment