Finding the nth root of a number in EXCEL

You can use the ^ operator to raise the number to power... you would just use the reciprocal of N (rather than N itself) for the Nth root. So...

NthRoot = Number ^ (1 / N)

where N is the root you want to take. For example, if you wanted the 5 root of 3125, you would do this...

FifthRootOf3125 = 3125 ^ (1 / 5)

NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.

If A1 contains the number and A2 the root:

=A1^(1/A2)

or

=EXP(LN(A1)/A2)

Example: A1 = 8, A2 = 3, Result: 2 because 2^3 = 8

Regards,

Bernd

http://www.sulprobil.com/html/excel_forums.html

With

A1: ...a number....eg 8

this formula  returns the cube root of that number:

B1: =A1^(1/3)

In that example, the formula returns: 2

(2x2x2=8)

This formula returns the square root:

B1: =A1^(1/2)

for other roots:

B1: =A1^(1/4)

B1: =A1^(1/5)

etc

Does that help?

Ron Coderre

Microsoft MVP (2006 - 2010) - Excel

P.S. If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)