Excel: Calculating the nth Root of a Number

ID: Q28572

2.x 3.x 4.x 5.00 5.00c 7.00 | 1.x 2.x 3.00 4.00 5.00 5.00a

WINDOWS                     | MACINTOSH

kbother kbusage

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.

KBCategory: kbother kbusage KBSubcategory: xlformula

Additional reference 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

Last Reviewed: March 25, 1999