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:
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:
When we use the formula of POWER, we get 5 as the CUBE ROOT of 225
Formula for nth root is POWER(NUMBER,1/n)
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.