**Finding the Nth Root of a Number**

To get the **Nth ROOT** of a number in Excel, one can apply a variety of ways. You can use the basic formula that involves a **CARET** mark with **1/n** being the power that the number is raised to. The **POWER function** with the corresponding power argument (**1/n**) can also be used.

When applying the **CARET** mark, the generic formula for the **Nth ROOT** determination is given below:

**=Cell containing the number **^ (**1/n**)

For the **POWER function**, the generic formula for the **Nth ROOT** determination is given below:

**=POWER(Cell containing the number or the number, 1/n)**

In example 1 below, the **Nth ROOT** of the number in **Cell E8** is treated using the **CARET MARK** while in example 2, the **POWER function** is used to determine the **Nth ROOT** of the number in **Cell E9**.

**How to Find the Nth Root of a Number**

**Example 1**

**Step 1**

Input your data as shown in figure 1 below.

**Step 2**

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

**Step 3**

Open a bracket and type the number, 1, insert a division mark and highlight **Cell D8** as shown in figure 3. Close the bracket and press the **ENTER** button. You should have the result in figure 4.

As a result, the basic formula, for example, one is `=C8^(1/D8)`

.

**Example 2**

With the same details we have, we can skip step one. The next step is to highlight **Cell E9 **and type the **POWER function** as shown in figure 5 below.

Now, highlight **Cell C9**. Place a comma, leave a space and type **1/D9**. Close the bracket.

When you hit the **ENTER** button, the result should be as displayed in figure 7 below.

As a result, the basic formula for example two is **=POWER(C9, 1/D9)**

## Leave a Comment