In this Article

*This tutorial will demonstrate how to find the cube root of a number in Excel & Google Sheets.*

*<<master image>>*

## Cube Root using Caret Operator (^)

To calculate the cube root of a number, you can use the Caret/Exponent (^) Operator or the POWER Function.

First, let’s see how to use the Caret Operator.

1 |
=B3^(1/3) |

The Caret Operator raises a number to a power. By raising, to 1/3 we take the cube root of a number (or the nth root).

Note: To control the order of operations make sure the exponential ‘1/3’ is in parentheses.

## Cube Root using POWER Function

The POWER function returns the result for a given number raised to a power. Its syntax is:

1 |
=POWER(B3,1/3) |

In order to find the cube root, make sure you enter 1/3 and not 3.

Note: Same process can be used to calculate the cube root of a negative number.

## Cube Root in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.