How do I get the nth root of a number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
How do you calculate the nth root of a number in Excel 2003? 2
how do you get excel o calculate antilogs 1
How to divide numbers in Excel? 0
Nth Root 3
exponentials 2
How do I calculate the root of a number using Excel? 4
how to find cubed root of a number 4

Back
Top