Download the example workbook
This tutorial will teach you how to calculate the nth root of a number in Excel and Google Sheets.
Calculating nth Root using Caret Operator (^)
We can find the nth root of a number by raising that number to the exponential ‘1/N’. To calculate the nth root of a number you can either use the Caret Operator (^) or the POWER function.
The Caret Operator can be used in the following manner:
The Caret Operator raises a number to power, by using a number between 0 and 1, we can take the root of the number. As shown in the first example above, by raising a number to 1/3, we can take the cube root of a number.
Note: Make sure ‘1/N’ is in parentheses to control the order of operations
Calculating nth Root using POWER Function
Alternatively, the nth root of a number can be calculated using the POWER function. Its syntax is:
Calculating nth Root of a Negative Number using ABS Function
Nth Root in Google Sheets
These formulas work exactly the same in Google Sheets as in Excel.