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.

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 find the Square root
Open an Excel file
Let’s find the square root of a number
Here the number is 169
The formula is
Square root =POWER(E3,1/2)

 

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

 

image1

 

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 find the Cube root
Cube root =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)



One thought 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

Leave a Reply

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


3 − = two

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>