Square root and cube root in Microsoft Excel 2010

In this article we will learn if  we want to get a root of a number, it is as same as raising that number to the power of 1/root in Microsoft Excel 2010.

Excel Square Root:

The square root of x is x^(1/2)
The square root of A1 is: =A1^(1/2)

Built-in worksheet function
SQRT: =SQRT(A1)

To calculate Square root in excel follow the below steps:

• Open an Excel file
• Let’s find the square root of a number
• Here the number is 169
• The formula is
• Square root formula=POWER(E3,1/2)

When we use the formula of POWER, we get 13 as the SQUARE ROOT of 169

Excel Cube Root:

The cube root of x is x^(1/3). The cube root of A1 is: =A1^(1/3)
You can also use the built-in worksheet function POWER: =POWER(A1;1/3)

To calculate Cube root in excel follow the below steps:

• Cube root formula =POWER(E3,1/3)
• Let’s check this formula
• Cube root of 125
• The formula is
• Cuberoot =POWER(E3,1/3)

When we use the formula of POWER, we get 5 as the CUBE ROOT of 225

Nth Root:

Formula for nth root is POWER(NUMBER,1/n)

6 thoughts on “Square root and cube root in Microsoft Excel 2010”

1. i try but i just want to write the power on top just like m raise power 3 example m3 this 3 i want to write on the top of m thanks any one reply me thanks

2. This is how you get presented on papers usually.. some universally agreed format of math people to understand each other. In digital world you need to present figures for apps to understand. And this is how you give commands to them.. in their language agreed by programmers. Essentials of programming would help you more, I guess )

3. I use the formulat Log10 (4) to calculate the log base 10 of 4. How can I
compute the inverse of log 10.

4. In general, if y = log10(x), then x = 10^y.

So, if you have =LOG10(4) in cell A1, showing approximately 0.60206, then
enter =10^A1 in some other cell, which will show 4.

5. The cube of 5 is 125 not 225 / cube root of 125 is 5. Cube root of 225 is 6.08. The typo needs correcting, other than that it was helpful