Square root and cube root in Microsoft Excel 2010

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/other-qa-formulas/square-root-and-cube-root-in-microsoft-excel.html">
SHARE




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

 

image1

 

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

 

IMAGE2
Nth Root:

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

Please follow and like us:
25


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

Leave a Reply

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


7 + = eleven

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>