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


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)

Users are saying about us...

  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. 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.

  4. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube