x square root y in excel

[Stuart]

I am having problems on excel trying to get the x root y
function. I know that the sqaure root function is
written "sqrt(x)" but if I want to find the root of a
number by a number other than 2, what do I type into
excel?

Thanks.

 

[Rick Hale]

Wrong group, but you can use the POWER function. POWER(10,1/3) will return
the cube root.

Rick

 

[Rob Schneider]

I am having problems on excel trying to get the x root y
function. I know that the sqaure root function is
written "sqrt(x)" but if I want to find the root of a
number by a number other than 2, what do I type into
excel?

Thanks.

This best asked of the number crunchers in the Excel newsgroups ... that
being said, this brings me back to basic math concepts learned a *few*
years back.

Excel's square root function is the special case of a number raised to
the power of 0.5

Excel's power function is the general case, e.g.

1.412=sqrt(2)
1.412=power(2,1/2) ... square root of 2
1.260=power(2,1/3) ... cubed root of 2
etc.

see the pattern?

A terrific reference for this sort of thing for your bookshelf would be
the CRC Standard Math Tables and Formulae
http://www.amazon.com/exec/obidos/t..._books_3/102-2291095-3779307?v=glance&s=books

 

[Guest]

-----Original Message-----
Wrong group, but you can use the POWER function. POWER (10,1/3) will return
the cube root.

Rick




.