How to figure roots in Excel?
 

How can I figure the y root of n for x, such as the power 6 root of 15625,
which is 5 (5^6 = 15625).

LOG(15625,5) = 6 but how do I do it the other way around, using 15625 and 6
to find 5?

One way:

=x^(1/y)


In article ,
Brion Kidder <Brion wrote:

How can I figure the y root of n for x, such as the power 6 root of 15625,
which is 5 (5^6 = 15625).

LOG(15625,5) = 6 but how do I do it the other way around, using 15625 and 6
to find 5?

Hi

=x^(1/x)
i.e.
=15625,5^(1/6) does return 5.000027


Arvi Laanemets


"Brion Kidder" <Brion wrote in message
...
How can I figure the y root of n for x, such as the power 6 root of 15625,
which is 5 (5^6 = 15625).

LOG(15625,5) = 6 but how do I do it the other way around, using 15625 and
6
to find 5?

If you prefer functions:
=POWER(A1, 1/6)

best wishes
Bernard

"Brion Kidder" <Brion wrote in message
...
How can I figure the y root of n for x, such as the power 6 root of 15625,
which is 5 (5^6 = 15625).

LOG(15625,5) = 6 but how do I do it the other way around, using 15625 and
6
to find 5?