# Calct the SQRT to power of three or a given argument,its always to the power of 2?

1. ## Calct the SQRT to power of three or a given argument,its always to the power of 2?

FOR EX:-
A
Data
-16
Formula Description (Result)
=SQRT(16) Square root of 16 (4)
=SQRT(A2) Square root of the number above. Because the number is negative, an error is returned (#NUM!)
=SQRT(ABS(A2)) Square root of the absolute value of the number above (4)

HOWEVER
IF I WANT TO GET THE CUBE ROOT OR THE ROOT TO THE POWER OF n
then is there any other function or any logic to do the above

for ex-the no is 27 i want the cube root ans shud be 3
or 2nd ex-no is 81 i want the root to the power 4 ans is 3 as (3^4)=81
thanx in anticipation  Register To Reply

2. The SQRT function is for square roots only. For other exponentials, you shoud use the ^ (carrot) symbol. For example...

=4^3 results in the answer 64.

To do cube roots, use a fractional exponent. For example =729^(1/3) results in the answer 9.

Therefore =27^(1/3) results in the answer 3.  Register To Reply