+ Reply to Thread
Results 1 to 1 of 1

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

  1. #1
    all4excel
    Guest

    Smile 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

  2. #2
    Forum Contributor
    Join Date
    01-24-2007
    Location
    Southampton, UK
    Posts
    137
    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.

+ 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