Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I a rotate my square radar chart (square-diamond)? Becs I Know Nathing Charts and Charting in Excel 5 April 3rd 23 07:30 PM
how do i use square root on excel - what is the formula Karen Excel Worksheet Functions 4 January 1st 07 11:15 AM
How to find square roots on paper esweckwerth Excel Worksheet Functions 2 November 26th 05 04:47 AM
square root function in excel (roots greater than 12) Mark Excel Discussion (Misc queries) 3 March 13th 05 12:03 AM
How to figure roots in Excel? Brion Kidder Excel Worksheet Functions 3 November 17th 04 06:34 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"