# How to Do Cube Root in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Aniruddah Alam

Hi, I am Md. Aniruddah Alam from Dhaka, Bangladesh. I completed my Bachelor's degree in Naval Architecture from BUET. Currently, I am working as an Excel and VBA Content Developer. Here, I always try to present solutions to Excel-related problems in a very concise and easy-to-understand manner. In my leisure time, I love to read books, listen to podcasts, and explore new things.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  