ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what is the formula in excel for higher level of square roots (https://www.excelbanter.com/excel-discussion-misc-queries/181437-what-formula-excel-higher-level-square-roots.html)

Cindy Nguyen

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

David Biddulph[_2_]

what is the formula in excel for higher level of square roots
 
=A2^(1/5) or =POWER(A2,1/5), if you want the 5th root.
--
David Biddulph

"Cindy Nguyen" <Cindy wrote in message
...
the formula for squre roots in excel is SQRT(number) but what is the
formula
for higher level of roots?




Gary''s Student

what is the formula in excel for higher level of square roots
 
With a value in A1:

=A1^(1/3) for the cube root of A1
--
Gary''s Student - gsnu200775


"Cindy Nguyen" wrote:

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


Barb Reinhardt

what is the formula in excel for higher level of square roots
 
Try Number ^ (1/n)
--
HTH,
Barb Reinhardt



"Cindy Nguyen" wrote:

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


Tyro[_2_]

what is the formula in excel for higher level of square roots
 
Read a book on basic Excel?

Tyro

"Cindy Nguyen" <Cindy wrote in message
...
the formula for squre roots in excel is SQRT(number) but what is the
formula
for higher level of roots?





All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com