Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Need help with a formula for multiple conditions

    Hi,

    I have a spreadsheet that contains multiple formulas. Overall the objective is to identify the individuals that are scheduled for a promotion. The catch is it is based on multiple conditions for each type. See attached for an example. Does anyone know how to do this formula? Or is there an easier way for me to do this in excel?

    Thank you!
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try this in Cell S3 and copy down.....
    =IF(OR(AND(B3="Hospital",D3=2),AND(B3="CV Rep",D3=2.1,O3="Yes",K3>50)),"Yes","No")

    PS: Assumes you wanted it based on 2009 Nat'l Ranking
    Last edited by tfspry; 2011-05-02 at 17:01. Reason: Added a PS:

  3. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    How do I incorporate multiple conditions? For example, I would like to say, If B3= Rep and C3 = CV and (D3 contains 1.1 or 1.0 or 1.2 or 2) and R3>=50 or s3>=50 then "YES" otherwise "Rule Does Not Apply"? Here is the formula that I tried but it isn't working. What am I doing wrong? I of course changed my values on my original spreadsheet attached to the values for each cell.

    =IF(AND(AND(B3="Rep",C3="CV",AND(OR(D3=1.1,1, 1.2, 2, ))),OR(R3>=50,S3>=50)),"Yes","Rule does not Apply")

    Any help would be much appreciated.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Try:
    =IF(AND(B3="Rep",C3="CV",OR(D3=1.1,D3=1, D3=1.2, D3=2),OR(R3>=50,S3>=50)),"Yes","Rule does not Apply")

    Steve

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    Corden (2011-05-16)

  6. #5
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thank you so much!!!! It worked. Very impressive.

    Corden

Posting Permissions

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