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:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.