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

Article translations Article translations
Article ID: 271143 - View products that this article applies to.
This article was previously published under Q271143
Expand all | Collapse all

On This Page

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.

Properties

Article ID: 271143 - Last Review: September 25, 2003 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster KB271143

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com