There is no specific known function for finding the cube or cube root in Excel, so you could use the exponential function instead. That is seemingly the easiest option.
How to find the Cube in Excel#
The syntax of the formula for finding the cube of a number in Excel is as follows:
Where, is the first cell in the range of cells from which you start counting the cube for the range of cells.
Eg. Let us consider an example where you have a range of numbers across column A from cell A3 to cell A11. You need the cube of these numbers in the respective columns across column B, from cells B3 to B11. To do so, enter the following formula in cell B3:
When you hit Enter, Excel will return the value of the cube of the number in cell A3 to the cell B3. Then, you can use the Fill function to pull the formula down to cell B11. To do so, click on any cell outside cell B3 (which contains the formula) and then back on it.
This will highlight the Fill function which is represented by a small dot at the right-bottom corner of the selected cell. Now, hover your mouse over that dot, click it, and without releasing the click, pull the formula down to cell B11.
How to find the Cube Root in Excel#
The syntax of the formula for finding the cube of a number in Excel is as follows:
Where, is the first cell in the range of cells from which you start counting the cube for the range of cells.
Eg. Let us consider the previous example and add that you need the list of cube roots in column C, from C3 to C11. So, the formula you would have to enter the following formula in cell C3:
Hit Enter to get the cube root for the number in cell A3 in cell C3 and then use the Fill function to pull the formula down till cell C11.
Read: How to find the Square and Square Root of a number in Excel.
Hope it helps!
