Any Root of a given Number

[Keith]

Is there a way to take any given number in a cell and
reduce it to any given root. Essentially this is the
exact opposite of taking number and raising it to any
given power?

e.g. If I have the number 32 in a cell, and wish to know
what the 5th root is, how do I do it? NB in this example
the answer is 2, because 2x2x2x2x2 = 32.

Sincerely

Keith

 

[duane]

use can use the power function and just have the power be <1 (say 0.
for the 5th root

 

[Jerry W. Lewis]

=x^y is the yth power
=x^(1/y) is the yth root

Jerry

 

[BenjieLop]

Keith,

Assume:

1. your number is in Cell A1
2. your root is in Cell B1

You can use two formulas:

=A1^(1/B1)

=Power(A1,1/B1)


<< Is there a way to take any given number in a cell and
reduce it to any given root. Essentially this is the
exact opposite of taking number and raising it to any
given power?

e.g. If I have the number 32 in a cell, and wish to know
what the 5th root is, how do I do it? NB in this example
the answer is 2, because 2x2x2x2x2 = 32.

Sincerely

Keith >