When you are weak in math, even a cube root becomes a huge deal🙅! So, to find out the cube root🤓 of a number in excel, here’s what you can do🤔:
As you can see in the image above, we have taken an example of a bunch of numbers of which we need to find out the cube root.
Now to do the same, we will begin with the equal to sign, as that’s how every formula begins. After the same, we will select the number in hand, i.e. 27 (cell B3).
Then we will input the caret sign ^
After inputting the caret sign, we will open the bracket and divide 1 by 3 and we will close the bracket after the same. We have divided 1 by 3 because we are looking for a cube root here.
So overall, the formula becomes as follows:
And BAAAAMMM🔫!!! Your answer is 3. The cube root of 27 is 3.
Now all you have to do is drag down the formula till its required (as shown in the image above☝).
And there you go🤷.
It’s easy, isn’t it😉?