Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get the nth root of a number?
Using Office XP. I need to get the 9th root of a number. If I go the route of:-
(log())/9 how do I get the antilog of the result? |
#2
|
|||
|
|||
A few ways. Using the Log, you'd just raise 10 to that power. That is the
9th root of x is 10^(log(x)/9) However, what may be easier is just doing it directly with x^(1/9). Also if x can be negative you'll have an easier time with x^(1/9), although you'll have trouble with even roots. Art "Keithg" wrote: Using Office XP. I need to get the 9th root of a number. If I go the route of:- (log())/9 how do I get the antilog of the result? |
#3
|
|||
|
|||
One way
=A1^(1/n) Regards, Peo Sjoblom "Keithg" wrote: Using Office XP. I need to get the 9th root of a number. If I go the route of:- (log())/9 how do I get the antilog of the result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
How do I get the nth root of a number? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |