answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar

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
Related questions

When formula involves cube root?

Then you calculate the cube root!


How do you calculate the QTcF?

QTcF relates to the Fridericia Correction Formula used in cardiology. To calculate the QTcF you apply the principle of QTcF = QT/Cube root (RR).


What is cube root of 4 times cube root of 12?

2 cube root 6


How can you find the side of a cube using a cube root?

The cube root is the side of a cube.


What is the formula of reciprocal ponderal index?

Height divided by the cube root of body mass (weight)


What is the cube root of 17?

What is the cube root of 17


What is the cube root of 2 multiply by the cube root of 2?

4


What is 2 cube root 24 plus 3 cube root 81?

2 cube root 24 plus 3 cube root 81 is 18.7492444


What is Cube root of 36 x the cube root of 3?

4.762203156 according to the calculator. Exact answer: the cube root of 108 = 3 times the cube root of 4.


What is the cube root of 256?

The cube root of 256 is: 5.11722995A:The cube root of 256 is 6.3496055.117229953 is 134. Not 256


What is the cube root of 6 in fraction?

Most square roots, cube roots, etc. - including this one - are irrational numbers. That means you can't write them exactly as a fraction. Of course, you can calculate the cubic root with a calculator or with Excel, then find a fraction that is fairly close to it.


What is the cube route of -3?

There is no such thing as a cube route. The cube root of -3 is -1.4422 (approx).There is no such thing as a cube route. The cube root of -3 is -1.4422 (approx).There is no such thing as a cube route. The cube root of -3 is -1.4422 (approx).There is no such thing as a cube route. The cube root of -3 is -1.4422 (approx).