+ Reply to Thread
Results 1 to 1 of 1

Calct the SQRT to power of any given argument,its always to the power of 2?

  1. #1
    all4excel
    Guest

    Question Calct the SQRT to power of any given argument,its always to the power of 2?

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

    FOR EX:-
    =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

    Plz i need help guys...?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    For cube root use ^(1/3). Or any root use ^(1/n).

    HTH

    Jason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1