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
Input your data as shown in figure 1 below.
Click on Cell E8 as shown in figure 2 and type the content as shown on the figure into the cell.
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
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