Help with the IF Function in Excel

Discussion in 'Software Q&A' started by h1ghn3zz, Aug 21, 2006.

Thread Status:
Not open for further replies.
  1. h1ghn3zz

    h1ghn3zz New Member

    Joined:
    May 21, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Suppose i wanna use a formula for the following example, how would i go about it?

    Column1 - Column2
    ------------------
    <1000----------NIL
    1000-2000----------220
    2000-3000----------330
    ..............
    10000-11000----------100 etc.

    When i enter the values in column1, column2 should show the values according to what has been entered in column1.

    Thnx
     
  2. MysticHalo

    MysticHalo Your Maker.

    Joined:
    Jan 3, 2006
    Messages:
    397
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    mumba][
    I did this using Office 2007 Beta 2...but i hope the working remains same-:
    >>syntax

    =if(logical_test,[value_if_true],[value_if_false])

    So, for your case, we go like this-:
    (in column 2)
    =IF(AND(A1<3000,A1>2000),330,IF(AND(A1<2000,A1>1000),230,"xyz")


    *(AND SO ON)
     
  3. sakumar79

    sakumar79 Active Member

    Joined:
    Nov 28, 2004
    Messages:
    2,441
    Likes Received:
    9
    Trophy Points:
    38
    Location:
    Madurai
    You would not need to use AND operator because of nested if.

    IF(A1<1000, 0, IF(A1<2000,220,IF(A1<3000,330,IF(...))))

    Arun
     
  4. OP
    OP
    h1ghn3zz

    h1ghn3zz New Member

    Joined:
    May 21, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Thank you both MysticHalo and sakumar79. MysticHalo's suggestion seems to be more useful because i need to 'nest' more than 7 arguments.

    Thanks again, guys.
     
Thread Status:
Not open for further replies.

Share This Page