Microsoft KB Archive/271143

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

Article ID: 271143

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q271143



For a Microsoft Excel 97 and earlier version of this article, see 28572.

IN THIS TASK
SUMMARY
 * Formula for nth Root in Excel



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 &quot;num&quot; is the number you want to find the root of and &quot;n&quot; is the root.

back to the top

Additional query words: how to exponent exponential caret karet carit carrot carot XL2000 example formula

Keywords: kbhowto kbhowtomaster KB271143

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.