How do I get the nth root of a number?

K

Keithg

I need to calculate the 9th root of a number. If I go the route of log()/9,
there is no function for antilog. Anybody help?
 
G

Gord Dibben

Try this instead

=number^(1/n)

Or =cellref^(1/n)

You could alo use the POWER function

=POWER(8,1/3) returns 2

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the nth root of a number? 2
Paragraph numbering in Word 1
How to divide numbers in Excel? 0
Finding the proper style field and the numbered paragraph value within the style 0
How to count the numbers in a Word document? 0
How do you calculate the nth root of a number in Excel 2003? 2
how to find cubed root of a number 2
Finding the right style field in VBA 0

Top