View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default How do I calculate the root of a number using Excel?

Interesting to see a thread from 2005 being revived! [And I don't think
that Arthur has posted to the group since then.]

One of the answers was in that thread, but there are two easy options.
To calculate the 4th root of A1, use either
=A1^(1/4)
or
=POWER(A1,1/4)
--
David Biddulph

"John" <John @discussions.microsoft.com wrote in message
...
Hi Arthur,

How can I use function for cube roots or even 4th roots

"Arthur Yeager" wrote:

The only root function I can find in Excel is the square root function.
How
can I use Excel to calculate third, fourth, fifth etc.. roots of a
number?