answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor

Add your answer:

Earn +20 pts
Q: How can you apply the cube root formula in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp