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.

**Generic Formula**

**=num^(⅓)**

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

**Example 1**

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.

**=POWER(range,⅓)**

Here the range parameter contains the cell number with the numeric value for which cube has to calculated and ⅓ is the exponent value.

**Example 2**

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*

## Leave a Comment