Excel: Calculating the nth Root of a Number

ID: Q28572

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.x, 4.x, 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.x, 4.x, 5.0, 5.0a
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows

SUMMARY

In Microsoft Excel, to find the nth root of a number, raise that number to the power of 1/n. For example, to find the cube root of 8 in a cell, type the following:

=8^(1/3)

The following is the general form of the equation

=num^(1/n)

where "num" is the number you want to find the root of, and "n" is the root.

Additional query words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00 exponent caret carit carrot carot exponential

Keywords : xlformula
Version : MACINTOSH:1.x,2.x,3.x,4.x,5.0,5.0a; WINDOWS:2.x,3.x,4.x,5.0,5.0c,7.0,97
Platform : MACINTOSH WINDOWS
Issue type :