Whenever it is required to calculate the cube root for a number the Excel worksheet makes use of two methods
- Using the caret(^) operator
- Using the POWER built-in function
Using the caret operator let us see how the caret operator is used to calculate the cube root of a given number.
How does the formula work?
- The cube root of a given number can be calculated using the caret “^” operator with its exponent as ⅓ and also note that ⅓ should be wrapped with parenthesis before used.
- This returns the cube root value of the given number
Let us give some random number and check the cube root of that particular number using the caret operator along with the exponent (⅓).
Figure 1. Result obtained by using the caret operator.
Using the power function
An alternative to the caret operator is the usage of the Excel POWER function, and the generic Formula is as shown below.
Here the range parameter contains the cell number with the numeric value for which cube has to calculated and ⅓ is the exponent value.
Let us use the same example for calculating their cube roots, but now let us use the POWER function. We see that the results in both the cases are same.
Figure 2. The result obtained by using the Excel POWER function