How to Calculate Square root and cube root in Microsoft Excel

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 x^{y}.

**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=x^{2} → √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.

=SQRT(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.

=POWER(F3,1/3) |

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

=POWER(D7,1/4) |

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.

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.

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

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 )

I use the formulat Log10 (4) to calculate the log base 10 of 4. How can I

compute the inverse of log 10.

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.

Thanks

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