There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.
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 to 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 not possible 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