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

Article translations
Close
Expand all | Collapse all

## 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.

## Properties

Article ID: 28572 - Last Review: August 16, 2005 - Revision: 1.1
##### 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
##### Keywords:
KB28572
Retired KB Content Disclaimer