Microsoft KB Archive/28572

= XL: How to Calculate the nth Root of a Number =

Article ID: 28572

Article Last Modified on 8/16/2005

-

APPLIES TO


 * Microsoft Excel 2.0 Standard Edition
 * Microsoft Excel 2.01
 * Microsoft Excel 2.1 Standard Edition
 * Microsoft Excel 2.10c
 * Microsoft Excel 2.10d
 * Microsoft Excel 3.0 Standard Edition
 * Microsoft Excel 3.0a
 * Microsoft Excel 4.0 Standard Edition
 * Microsoft Excel 4.0a
 * Microsoft Excel 4.0c
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 1.0 for Macintosh
 * Microsoft Excel 1.03 for Macintosh
 * Microsoft Excel 1.04 for Macintosh
 * Microsoft Excel 1.06 for Macintosh
 * Microsoft Excel 1.5 for Macintosh
 * Microsoft Excel 1.5a for Macintosh
 * Microsoft Excel 2.2 for Macintosh
 * Microsoft Excel 2.2a
 * Microsoft Excel 3.0 for Macintosh
 * Microsoft Excel 4.0 for Macintosh
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 5.0a for Macintosh
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q28572





SUMMARY
In Microsoft Excel, 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)

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.

Additional query words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00 exponent caret carit carrot carot exponential

Keywords: KB28572

-

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

© Microsoft Corporation. All rights reserved.