Thread: Checking if 2 of 3 conditions are met...
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ed
 
Posts: n/a
Default Checking if 2 of 3 conditions are met...
Try this formula:

=IF(OR(AND(E3="Y",H3=10),AND(E3="Y",I3="Win"),AND (H3=10,I3="Win")),"PASS","")
Reply With QuoteReply With Quote