=IF(OR(AND(E3="y",OR(H3=10,I3="win")),AND(H3=10,I3 ="win")),"Pass","Fail")
Vaya con Dios,
Chuck, CABGx3
"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