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

DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake
ReneRene
Change my mind. I dare you.
Chat with Rene

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