Root?

[terryc]

Hi,

I want to get the "root" of a number, but not the square root. I don't really know the mathematical terminology for this, but as an example:

4 to the power 6 = 4096

If I wanted to get 4096 back to the original figure of 4, (i.e. by using the "root 6"), how would I do it?

Thanks!

 

[GlennUK]

Inverse power would get you what you want. So if you have 4096 in cell A2, then the "root 6" of it would be:

=A2^(1/6)

 

[pgc01]

Hi terryc

try

=4096^(1/6)

Hope this helps
PGC

 

[Richard Schollar]

Hi

You can reverse what you've done:

4096 = 4^6

Therefore:

4 = 4096^(1/6)

Richard