Squared root

**naungsai** · 02-10-2010, 11:06 PM

Hi Friends

In the calculation of 1000=10*10*10.
How can i get the result "10" with the function of "1000"?

In the calculation of 16= 2*2*2*2
How can i get the result "2" with the function of "16"?

Thanks in advanced.
Sai

**JBeaucaire** · 02-10-2010, 11:20 PM

The POWER() function can be used to "reverse" out a cube root, or even higher.

To get the cube root of 1000:

=POWER(1000, 1/3)
...result 10.

=POWER(16, 1/4)
...result 2.

**naungsai** · 02-10-2010, 11:25 PM

Thank you very much.

**JBeaucaire** · 02-10-2010, 11:35 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)