x square root y in excel

  • Thread starter Thread starter Stuart
  • Start date Start date
S

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.
 
Wrong group, but you can use the POWER function. POWER(10,1/3) will return
the cube root.

Rick
 
Stuart said:
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.
Click to expand...

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
 
Back
Top