Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want to raise a number, x, to the power "n", the way to do this in
Excel is: =x^n. To do the "opposite" (i.e. take the "n"th root of x), then you need to type in the following: =x^(1/n). Note that you need to put the brackets in as if you just put: =x^1/n, what this will do is raise x to the power 1 (i.e. it will stay at x), then divide this by n. The above equation thus effectively reads: =x/n The brackets in the correct expression [=x^(1/n)] ensure that the root of the equation is calculated correctly. "Dave" wrote: Can someone please tell me how to use a qube root in an equation. I know SQRT(x) is the opposite of x^2, but i want to know how to do the opposite of x^3 or x^?. Appreciate any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to calculate a cube root | New Users to Excel | |||
how do you calculate the 5th square root in MS Excel? | Excel Worksheet Functions | |||
What is the formula for cube root on Excel? | Excel Worksheet Functions | |||
Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |