Cube root of number

Cube root of number

Generic formula 

=number^(1/3)

Related formulas 

Square root of number

nth root of number

Explanation

To get the cube root of a number, you can use the caret(^) operator with 1/3 as the exponent in a simple formula. In the example shown, the formula in C5 is:

=B5^(1/3)

How this function works

The cube root of a number can be calculated by raising a number to the (1/3). Be sure to wrap the fraction in parentheses.

If this idea is new to you, Khan Academy has great videos on the topic.

With the POWER function

The POWER function can also be used to calculate a cube root of a number by supplying 1/3 as the power argument.

=POWER(A1,1/3)

Cube root of number

Generic formula 

=number^(1/3)

Related formulas 

Square root of number

nth root of number

Explanation

To get the cube root of a number, you can use the caret(^) operator with 1/3 as the exponent in a simple formula. In the example shown, the formula in C5 is:

=B5^(1/3)

How this function works

The cube root of a number can be calculated by raising a number to the (1/3). Be sure to wrap the fraction in parentheses.

If this idea is new to you, Khan Academy has great videos on the topic.

With the POWER function

The POWER function can also be used to calculate a cube root of a number by supplying 1/3 as the power argument.

=POWER(A1,1/3)