what is the formula in excel for higher level of square roots

Thread view:

Thread rating:

Cindy Nguyen - 27 Mar 2008 00:11 GMT

the formula for squre roots in excel is SQRT(number) but what is the formula
for higher level of roots?

David Biddulph - 27 Mar 2008 00:14 GMT

=A2^(1/5) or =POWER(A2,1/5), if you want the 5th root.
--
David Biddulph

> the formula for squre roots in excel is SQRT(number) but what is the
> formula
> for higher level of roots?

Gary''s Student - 27 Mar 2008 00:16 GMT

With a value in A1:

=A1^(1/3) for the cube root of A1

Signature

Gary''s Student - gsnu200775

> the formula for squre roots in excel is SQRT(number) but what is the formula
> for higher level of roots?

Barb Reinhardt - 27 Mar 2008 00:17 GMT

Try Number ^ (1/n)

Signature

HTH,
Barb Reinhardt

> the formula for squre roots in excel is SQRT(number) but what is the formula
> for higher level of roots?

Tyro - 27 Mar 2008 00:40 GMT

Read a book on basic Excel?

Tyro

> the formula for squre roots in excel is SQRT(number) but what is the
> formula
> for higher level of roots?