How to Take the Nth Root in Excel

Written by brian valle
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Take the Nth Root in Excel
Raising a number to the power of 1/n gives its nth root. (Ryan McVay/Photodisc/Getty Images)

Microsoft Excel does not have a generic ROOT function which returns the nth root of a number. Nevertheless, you can still use Excel to perform calculations that require you to extract roots. In general mathematics, you can obtain the root of a number by raising it to the power of a fraction. For example, raising 4 to the power of 1/2 will give you its square root, which is 2. With this in mind, you can use Excel's basic math operators or the POWER function to compute for the nth root of a number.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Launch Excel. Create a new workbook, or open the file that you'd like to work on.

  2. 2

    Select the cell where you'd like to insert the nth root. Press "F2" to edit it.

  3. 3

    Enter one of the formulas below into the cell. Replace "x" with the number from which you'd like to extract the root. You may use a cell reference, name, or another formula in place of "x."

    =POWER(x, 1/n)

    =x^(1/n)

  4. 4

    Replace "n" with the root you'd like to obtain. For example, replace it with 3 if you'd like to get the cube root, or use 2 if you'd like to obtain the square root. Press "Enter" to see the result of your formula.

Tips and warnings

  • Excel comes with a SQRT function that takes any number and returns its square root. To use it, enter "=SQRT(n)" into an empty cell and then replace "n" with a number, a cell reference, or another formula.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.