How to Calculate Nth Root in Excel (Formula)

puneet-gogia-excel-champs

- Written by Puneet

The easy and quick way to get the nth root of a number is to use the caret operator. Otherwise, you can use Excel’s POWER function. In this tutorial, you will learn to use both methods.

calculate-nth-root

Let’s calculate the 10th root for the number 1953125.

Use CARET (^) Operator to Get the Nth Root of a Number

You can use the below steps:

  1. First, enter the equal operator in a cell and refer to the number for which you want to get the nth root.
  2. After that, enter the caret operator.
  3. Next, enter the starting parentheses.
  4. Now, enter 1/10 as you need to calculate the 10th root.
  5. In the end, enter the closing parentheses and hit enter to get the result.
caret-operator-to-get-nth-root
=A1^(1/10)

Let’s say you want to calculate any other root for a number; you need to change the nth number from the formula:

=original_number^(1/nth_root)

Ensure that (1/nth_root) is always in the brackets to have the right order of operations in the calculation.

Calculate Nth Root with POWER Function

You can use the below steps:

  1. First, enter the POWER function in the cell and the starting parentheses.
  2. Now, in the first argument, refer to the original number.
  3. Next, in the second argument, enter 1/10.
  4. In the end, enter the closing parentheses and hit enter to get the result.
power-function-to-get-nth-root
POWER(A1,1/10)

In this method, you must divide 1 with the nth root to get the result. The only difference is that you don’t need to use the caret operator.

For both methods, you need to change the nth root. Change it in the formula if you want to get the 4th, 5th, or any other root.

Nth Root for a Negative Number

If you have a negative number and you want to get the nth root of that number, you need to use the ABS function just like the following examples:

nth-root-for-negative-number
=ABS(A1)^(1/10)
=POWER(ABS(A1),1/10)

Get the Excel File

Last Updated: December 26, 2023