Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


Keywords: KB271143, kbhowtomaster, kbhowto

↑ Back to the top

Article Info
Article ID : 271143
Revision : 3
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 199