Manually with ^
The cube root of a number can be calculated manually by raising a number to the (1/3) using the exponentiation operator (^). In the example shown, the formula in C5 is:
Be sure to enclose 1/3 in parentheses to control the order of operations.
With the POWER function
The cube root of a number can also be calculated with the POWER function, by supplying 1/3 as the power argument. The equivalent formula is: