=IF(OR(AND(N,Y,A),AND(Y,Y,B),AND(Y,Y,C)),结果一,(IF(OR(AND(Y,Y,A),AND(Y,Y,B)),结果二,""))
具体如液或图,
=IF(OR(AND(A2="N",B2="Y"碰态,C2="A"),AND(A2="N",B2="Y",C2="B"),AND(A2="Y",B2="Y",C2="C")),"结果笑埋源一",IF(OR(AND(A2="Y",B2="Y",C2="A"),AND(A2="Y",B2="Y",C2="B")),"结果二",""))
用IF(OR(条件1=NYA,条件2=YYC),结果一,IF(条件3=YYA,结果二含拍),""))
意思是如果条谈族羡件1或条件2,同时满足一穗晌个,即返回结果一;如果满足条件3,则返回结果二;否则的话,返回空白.
用表格表示出你的意思,这样看不大明白。
=if(Or(And(N,Y,or(A,B),And(Y,Y,C)),"空晌结果一“清消,if(And(Y,Y,or(A,B),"结果二“,"其它"答亏知)
如果以上条件都不满足又会是什么样的结果呢