There are several stages to the calculation. These can be summarized in the formula
=10^(LOG(x)/3)
Where x = the number you want to find the cube root of. Excel example:
In cell A1 enter the number you want to find the cube root of. e.g. 125
In cell B1 enter the formula '=10^(LOG(A1)/3)' [omitting the 'quote' marks]
The formula will return the answer 5, which is the cube root of 125. [5x5x5=125] Explanation of formula: * LOG (x) converts the original number to a logarithm. * /3 divides the Log by three * 10^ raises 10 to the power of the result of the previous calculations The equals ('=') sign is required when writing formulas into cells in Excel.
Unfortunately there is no short way to find the cube root in excel, but the square root can be found by using =SQRT(number) An infinite number of 'roots' can be found by using =10^(LOG(x)/3). Just change the '3' to a number of your choice.
Chat with our AI personalities
2 cube root 6
What is the cube root of 17
4.762203156 according to the calculator. Exact answer: the cube root of 108 = 3 times the cube root of 4.
The cube root of 256 is: 5.11722995A:The cube root of 256 is 6.3496055.117229953 is 134. Not 256
cube root (4) = 1.58740105.