< Go Back

Cube root of number

Whenever it is required to calculate the cube root for a number the Excel worksheet makes use of two methods

  1. Using the caret(^) operator
  2. 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?

  1. 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.
  2. 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

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar