# Thread: Need help with a formula for multiple conditions

1. ## 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!

2. 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

3. 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. 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. 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
•