Co-Authored By:

##### Asked by: Bismark Hagenbuchner

science physics# How do you find the nth square root in Excel?

Last Updated: 29th March, 2020

**Excel**has no built-in function to calculatethe

**nth root**of a number. To calculate the

**nth root**ofanumber, simply raise that number to the power of 1/n. 6.Forexample, 5 * 5 * 5 or 5^3 is 5 raised to thethirdpower.

Click to see full answer.

Consequently, how do you find the nth root of a number in Excel?

**Software**

- Calculate a square root. The syntax for the SQRT() functionis:=SQRT(number)
- Calculate an nth root. Use the POWER() function to calculateanyroot value: =POWER(number,(1/n))
- Calculate roots of imaginary numbers. Excel offers theIMSQRT()and IMPOWER() functions to return roots and powers ofimaginarynumbers.

Additionally, how do I find under root in Excel? **Top 5 Ways to Calculate SQUARE Root in Excel**

- SQRT(number)
- =SQRT(A1)
- =SQRT(ABS(A1))
- POWER(number, power)
- =POWER(A1,1/2)
- =A1^(1/2)
- =Number.Sqrt([Numbers])
- √General.

Consequently, how do you square a number in Excel?

**Square a number**

- Click inside a cell on your worksheet.
- Type =N^2 into the cell, where N is the number you wanttosquare. For example, to insert the square of 5 into cell A1,type=5^2 into the cell.
- Press Enter to see the result. Tip: You can also clickintoanother cell to see the squared result.

How do you find the 6th root?

The **sixth root** of a number is the numberthatwould have to be multiplied by itself 6 times to get theoriginalnumber. For example, the **sixth root** of 729 is 3 as 3x 3 x 3x 3 x 3 x 3 is 729. The **sixth root** of 4,096 is 4, as4 x 4 x4 x 4 x 4 x 4 is 4,096.