A2oz

How to Calculate Cube Root in Excel?

Published in Excel Formulas 2 mins read

You can calculate the cube root of a number in Excel using the POWER function.

Using the POWER Function

The POWER function takes two arguments: the base number and the exponent. To calculate the cube root, you need to use the exponent 1/3.

Here's the formula:

=POWER(number, 1/3)

Replace number with the cell containing the number you want to find the cube root of.

Examples

Example 1:

To find the cube root of 27, use the following formula:

=POWER(27, 1/3)

This will return the value 3.

Example 2:

If the number 64 is in cell A1, you can find its cube root using the formula:

=POWER(A1, 1/3)

This will return the value 4.

Practical Insights

  • The POWER function can be used to calculate any root of a number, not just the cube root. You can simply change the exponent to the desired root.
  • If you need to calculate the cube root of a range of numbers, you can use the POWER function with an array formula.

Conclusion

By using the POWER function with an exponent of 1/3, you can easily calculate the cube root of any number in Excel.

Related Articles