View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JonR
 
Posts: n/a
Default Checking if 2 of 3 conditions are met...

Put this into your target cell

=IF(OR(AND(E3="Y",H3=10),AND(E3="Y",I3="Win"),AND (H3=10,I3="Win")),"Pass","Fail")

--
HTH

JonR


"guilbj2" wrote:


I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556935