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
Bookmarks