You are currently offline, waiting for your internet to reconnect

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

This article was previously published under Q271143
For a Microsoft Excel 97 and earlier version of this article, see 28572.

IN THIS TASK

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

back to the top
how to exponent exponential caret karet carit carrot carot XL2000 example formula
Properties

Article ID: 271143 - Last Review: 09/25/2003 13:08:00 - Revision: 3.0

Microsoft Excel 2000 Standard Edition

  • kbhowto kbhowtomaster KB271143
Feedback