In this article, we will find out how to calculate the square root and cube root of a number. We will also find out the nth root of a number by using the POWER function in Excel 2016.
x, to the power of y, is referred to as xy.
The Root of a number is inverse of Power of the number.
Square of a number = Power(2) of a number
The square root of a number = power(½) of a number
|y=x2 → √y =x|
SQRT function is used when we need to find the square root of a number in Excel.
Syntax of SQRT:
|=SQRT(number or cell reference)|
POWER function is used when we need to find out the exponent of a number in Excel.
Syntax of POWER:
|=POWER(number or cell reference, 1/3)|
Let’s take some examples as shown below
Use the formula to find the square root of the number in cell B3.
Press Enter to see the square root of 25.
The square root of 25 is 5.
To find out the cube root of a number, we will use the POWER function.
Write the formula in the desired cell.
Press keyboard key Enter to see the cube root of the number in cell F3.
Cube root of 125 is 5.
Let’s see below to find out the nth root of a number by using the above method.
Use the formula
Press key Enter to view your output
Power(4) of 5 is 625.
So, 4th root of 625 is 5.
You can customize your formula with these basic functions. As you can see by using the mathematical function in Excel you can perform many exponents function. Please do find more articles on the mathematical formulation here.
Hope you understood this article. Please share your query in the comment box below. We will help you.
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.