There is no cube root function in Excel. However, a solution exists to perform a cube root calculation with another Excel function.
- The SQRT function
The SQRT function return the SQuare RooT of a number
- The POWER function
To find a cube root, you need to use the POWER function and manipulate the power argument.
What is a cube root?
Let’s say you multiply 3 times the same number. For example,
=4*4*4 => 64
Or you can also use the POWER function
=POWER(4,3) => 64
So, the cube root of 64 is 4
And the writing of this formula is:
How do you make a cube root in Excel?
Despite more than 500 functions, there is no cube root function in Excel 😲😱😡 There is the SQRT function (for SQuare RooT) which returns the square root of a number. But no Cube Root function or nth root for that matter.
Also, before Windows 10, the scientific calculator of Windows has this option. Since then, this option has been removed from the scientific calculator.
Even if the function doesn’t exist, it is impossible to do the calculation 😉 For that, we will use the POWER function. Let’s start with a simple square root calculation. A square root is also the fact of raising a number to the power of 1/2
=ROOT(81) => 9
So in the case of a square root, we might as well write
=POWER(81,1/2) => 9
So to make a cube root, you must apply a power of 1/3 to your number.
=POWER(125,1/3) = 5
