As Excel does not provide any special function for finding the cube root of a number one may find it difficult to do cube root in Excel. If you are wondering how to cube root in Excel, you have come to the right place. So, let’s explore the easiest methods for accomplishing the task.
In this section, we will show 3 effective methods to do cube root in Excel.
1. Using Generic Formula to Do Cube Root in Excel
We can find out the cubic root of any number by applying the basic formula that is =(Number)^⅓. In excel, if we have a list of numbers and we want to find the cube root, we have to write the following formula.
=B4^(1/3)
- You will get the following result.
- Now to apply the same formula to cell C5 to C8, simply place the mouse cursor to the bottom right corner C4, and a + sign should appear. Now, drag the + sign from the C4 to C8 like this.
- You will have the following results.
2. Applying Excel POWER Function to Do Cube Root
We can also use the POWER function to find the Cube Root of any number. The formula is
=POWER(Number,1/3)
Here is an example of applying this formula:
- Type the formula below in cell C4.
=POWER(B4,1/3)
- You should get the following result.
- Now if we want to apply a similar formula for C5 to C8, bring your mouse cursor to the bottom right corner of C4. Now when you see the + sign, drag it down to C8.
- You should get the result like this below.
3. Using VBA Code to Do Cube Root in Excel
We can also create a custom function to find cube root by writing VBA code in excel. To do that follow the steps below:
Step 01:
- Press Alt+F11 to open the ‘Microsoft Visual Basic for Applications’ You can also do that by going to the Developer ribbon and selecting the Visual Basic option.
- You will see a window like this.
- Now go to the top menu bar and click on Insert, you will see a menu like the picture below. Now, from the menu, select the “Module”.
- Here, a new “Module” will appear.
Step 02:
- Now paste the following VBA code into the box.
Function cuberoot(Number)
cuberoot = Number ^ (1 / 3)
End Function
- By writing the code, we have actually created a custom function named cuberoot. Now we will use this function to find the cube root. Here is the formula:
=cuberoot(B4)The result should be like this
You can also apply the formula for cells C5 to C8 by following the same process stated in the previous methods. The results should be just like before.
Things to Remember
- Use the 1st and 2nd methods if your data is comparatively in a small quantity.
- If you need to find cube root frequently then you should consider the 3rd method.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
If you find this article helpful, please share this with your friends. Let us know your feedback in the comment section.
