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)

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

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

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 )

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

compute the inverse of log 10.

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.

Thanks

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