IF function with multiple ORs

Hello!

I was wondering if anyone could help a little, I'm not an Excel Pro I'm afraid! I'm trying to figure out a formula for the IF function with, I'm guessing it would be multiple ORs. I've attached an image, I hope it works. Let me explain:

I would like Q2 to say 'Yes' if

O2+O3+O4 = 50% and Risk Level (P2) is 2 or less

OR

O2+O4 = 75% and Risk Level (P2) is 3

OR

O2+O3+O4 = 100% and Risk Level (P2) is 4

And if possible to say 'No' if neither of the above is True

I hope that makes sense. If anyone has any idea what the formula for that would be I would be very grateful for any tips or advice!

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

=or(and(o2+o3+o4 = 0.5, p2<=2),and(o2+o4 = 0.75, p2=3),and(o2+o3+o4 = 1, p2=4))

Ooops. Sorry I forgot to finish this off.

=If(or(and(o2+o3+o4 = 0.5, p2<=2),and(o2+o4 = 0.75, p2=3),and(o2+o3+o4 = 1, p2=4),"Yes","No")

I think there's a missing bracket:

=If(or(and(o2+o3+o4 = 0.5, p2<=2),and(o2+o4 = 0.75, p2=3),and(o2+o3+o4 = 1, p2=4)),"Yes","No")

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Alternative:

=IF(CHOOSE(P2,0.5,0.5,0.75,1)=O2+O4+(P2<>3)*O3,"Yes","No")