Article ID: 271143 - Last Review: September 25, 2003 - Revision: 3.0

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

This article was previously published under Q271143

On This Page

Expand all | Collapse all

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)

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.


APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster KB271143
 

Article Translations