nth root of number

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)

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

Leave a Comment

avatar