How can you apply the cube root formula in Excel?

Answer 1

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.