To calculate the nth root of a number, raise it to the power of 1/n: =A1^(1/3) for the cube root, =A1^(1/5) for the fifth root, and so on. =POWER(A1,1/3) does exactly the same thing if you prefer a named function. The parentheses around 1/3 are essential — without them, =A1^1/3 divides the result by 3 instead.
Negative numbers need care: an odd root of a negative number is a real number (the cube root of -125 is -5), and you get it with =SIGN(A1)*ABS(A1)^(1/3). An even root of a negative number has no real answer at all, so =A1^(1/4) correctly returns #NUM! and no formula will fix that.
The most common practical use of an nth root is compound growth: =(End/Start)^(1/Years)-1 gives the CAGR, so a value growing from 100 to 250 over 5 years works out at about 20% a year.
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.

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:
- First, enter the equal operator in a cell and refer to the number for which you want to get the nth root.
- After that, enter the caret operator.
- Next, enter the opening parenthesis.
- Now, enter 1/10 as you need to calculate the 10th root.
- In the end, enter the closing parenthesis and hit Enter to get the result.

=A1^(1/10)
Let’s say you want to calculate any other root for a number; you need to change the nth number in 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. Without them, =A1^1/10 raises A1 to the power of 1 and then divides it by 10.
Calculate Nth Root with POWER Function
You can use the below steps:
- First, enter the POWER function in the cell and the opening parenthesis.
- Now, in the first argument, refer to the original number.
- Next, in the second argument, enter 1/10.
- In the end, enter the closing parenthesis and hit Enter to get the result.

=POWER(A1,1/10)
In this method, you must divide 1 by n (the root you want) 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 can use the ABS function, just like the following examples. ABS removes the minus sign, so these formulas return the root of the positive number (for -32 and the 5th root, they return 2, not -2):

=ABS(A1)^(1/10) =POWER(ABS(A1),1/10)
Here’s how negative numbers work in Excel. An even root (2nd, 4th, 10th) of a negative number doesn’t exist in real numbers, so =A1^(1/10) returns the #NUM! error. An odd root (3rd, 5th) does exist and is negative: the 5th root of -32 is -2, and =A1^(1/5) usually returns it. But Excel’s results for negative numbers with fractional powers aren’t always consistent, so the safest way is to keep the sign of the number with the SIGN function:
=SIGN(A1)*ABS(A1)^(1/5)
Only use this for odd roots. For an even root of a negative number, the result of this formula isn’t a real root; it’s just the root of the positive number with a minus sign.
Use a Cell for the Root
Instead of changing the formula every time, put the root in a cell and refer to it. With the number in A1 and the root (like 10) in B1, this formula returns the nth root for any value of n you enter in B1:
=A1^(1/B1)
For the square root, you can also use the SQRT function, like =SQRT(A1). It does the same as =A1^(1/2).
Check the Result
To check that the root is correct, raise the result back to the power of n. If the root is in C1, the following formula returns the original number (1953125 in our example):
=C1^10
Don’t worry if the root has many decimals. The 10th root of 1953125 is about 4.2567, as 1953125 is 5 to the power of 9, not 10. Use ROUND if you only want to show a few decimal places.
Frequently Asked Questions
Why does my nth root formula return #NUM!?
You are taking an even root (or a fractional power like 2/3) of a negative number, which has no real result. Use ABS or SIGN as shown above, depending on what you need.
Why is my result much bigger than expected?
The 1/n part isn’t in brackets. Excel calculates the power before the division, so =A1^1/10 gives A1 divided by 10. Write it as =A1^(1/10).
Is there an NTHROOT function in Excel?
No. Excel only has SQRT for the square root. For any other root, use the caret operator or the POWER function with 1/n.
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.