It is possible to find the cube and cube root of a number using simple formulas in Excel. You can use the same formula in Excel, Excel Online, and Google Sheets to calculate the cube root or cube of any number or value.
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:
=<first cell with number>^3
Where <first cell with number> 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:
=A3^3
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:
=<first cell with number>^(1/3)
Where <first cell with number> 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:
=A3^(1/3)
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 to cell C11.
Read: How to find the Square and Square Root of a number in Excel.
How to find the cube root of a number in Excel?
To find the cube root of a number in Excel, you need to use a formula like this: =<first cell with number>^(1/3). Let’s say the number if given in the A1 cell. In that case, you need to enter the formula like this: =A1^(1/3). It will be calculated immediately.
How to find cube value in Excel?
To find the cube value in Excel of any number, select a cell where you want to display the result and enter a formula like this: =<first cell with number>^3. For example, your number is in the A1 cell. That said, you need to enter the formula like this: =A1^3.
