HOW TO: Calculate the nth Root of a Number in Excel 2000 (271143)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q271143
For a Microsoft Excel 97 and earlier version of this article, see 28572.

IN THIS TASK

SUMMARY

This step-by-step article shows you how to find the nth root of a number in Microsoft Excel 2000.

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)

back to the top

Formula for nth Root in Excel

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.

back to the top

Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbhowto kbHOWTOmaster KB271143