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