software

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?

Use exponentiation. Ex: =64^(1/2) for square root, =64^(1/3) for cube root,
etc.

quot;Arthur Yeagerquot; wrote:

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

Brilliant! Thanks for the help.quot;bpeltzerquot; wrote:

gt; Use exponentiation. Ex: =64^(1/2) for square root, =64^(1/3) for cube root,
gt; etc.
gt;
gt; quot;Arthur Yeagerquot; wrote:
gt;
gt; gt; The only root function I can find in Excel is the square root function. How
gt; gt; can I use Excel to calculate third, fourth, fifth etc.. roots of a number?

Hi Arthur,

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

quot;Arthur Yeagerquot; wrote:

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

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

quot;Johnquot; lt;John @discussions.microsoft.comgt; wrote in message
...
gt; Hi Arthur,
gt;
gt; How can I use function for cube roots or even 4th roots
gt;
gt; quot;Arthur Yeagerquot; wrote:
gt;
gt;gt; The only root function I can find in Excel is the square root function.
gt;gt; How
gt;gt; can I use Excel to calculate third, fourth, fifth etc.. roots of a
gt;gt; number?