Thread: Qube Root?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary T
 
Posts: n/a
Default Qube Root?

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!