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:
The following is the general form of the equation
where "num" is the number you want to find the root of, and "n" is the
root.
| Modification Type: | Minor | Last Reviewed: | 8/16/2005 |
|---|
| Keywords: | KB28572 |
|---|
|