Excel root function

[maci]

How do I take the cube root or other higher root of a
number?

 

[Anon]

How do I take the cube root or other higher root of a
number?

For a number in A1, use
=A1^(1/3)
Replace the 3 with whichever root you want.

 

[Chip Pearson]

Maci,

The Nth root of any number is that number raised to the 1/N power.
E.g,

=A1^(1/3) for the cube root, or
=A1^(1/4) for the fourth root, and so on


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Gilles Desjardins]

Maci, I think that one uses the power symbology. Example: 5^(1/3) gives you
1.709976 the cubic root of 5.

I am bad in math but try it and tell me if this works for you.

HTH

Gilles