Excel formula: Cube root of number | cube root excel
Excelofferssomegreattoolsformathematicalcalculations.Oneoftheseistocalculatethecuberootofanumber.Tofindthecuberootofanumber,wecanusethecaretoperator()orthePOWERfunction.Inthistutorial,wewilllearnhowtocalculatethecuberootofanumberinExcel.Figure1.ExampleofHowtoCalculatetheCubeRootofaNumberSyntaxtoCalculateCubeRootusingtheCaretOperator=Num(1/3)Wecangetthecuberootofanumberusingthecaretoperatorwiththeexponent1/3.Thecaretoperatorraisesthenumbertoits1/3powerwhichisequivalenttoitscuberoot.SettingUpD...
Excel offers some great tools for mathematical calculations. One of these is to calculate the cube root of a number. To find the cube root of a number, we can use the caret operator () or the POWER function. In this tutorial, we will learn how to calculate the cube root of a number in Excel.
Figure 1. Example of How to Calculate the Cube Root of a Number
Syntax to Calculate Cube Root using the Caret Operator=Num(1/3)
We can get the cube root of a number using the caret operator with the exponent 1/3. The caret operator raises the number to its 1/3 power which is equivalent to its cube root.
Setting Up DataThe following example contains some sample numbers. Column A has these numbers.
Figure 2. The Sample Data Set
To get the cube roots in column B using the caret operator:
We need to go to cell B2. Assign the formula =A2(1/3) to cell B2. Press Enter.Figure 3. Example of Applying the Caret Operator to the Formula
Drag the fo...