XL: How to Calculate the nth Root of a Number (28572)


The information in this article applies to:

  • Microsoft Excel for Windows 2.0
  • Microsoft Excel for Windows 2.01
  • Microsoft Excel for Windows 2.1
  • Microsoft Excel for Windows 2.10c
  • Microsoft Excel for Windows 2.10d
  • Microsoft Excel for Windows 3.0
  • Microsoft Excel for Windows 3.0a
  • Microsoft Excel for Windows 4.0
  • Microsoft Excel for Windows 4.0a
  • Microsoft Excel for Windows 4.0c
  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for the Macintosh 1.0
  • Microsoft Excel for the Macintosh 1.03
  • Microsoft Excel for the Macintosh 1.04
  • Microsoft Excel for the Macintosh 1.06
  • Microsoft Excel for the Macintosh 1.5
  • Microsoft Excel for the Macintosh 1.5a
  • Microsoft Excel for the Macintosh 2.20
  • Microsoft Excel for the Macintosh 2.2a
  • Microsoft Excel for the Macintosh 3.0
  • Microsoft Excel for the Macintosh 4.0
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for the Macintosh 5.0a
  • Microsoft Excel for Windows 95
  • Microsoft Excel 97 for Windows
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 "num" is the number you want to find the root of, and "n" is the root.
Modification Type:MinorLast Reviewed:8/16/2005
Keywords:KB28572
©2004 Microsoft Corporation. All rights reserved.