EXCEL怎么设定满足3个条件出2种结果的IF函数,求大师帮助!答:=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",...
excel中if函数三个条件均大与100,则显示为优良,否则为空格,,怎么填写...答:=if(and(a1>100,b1>100,c1>100),"优良","")或 =if(and(a1:C1>100),"优良","")后一个是数组公式。
...测试条件多个真值结果怎么写到一起,(起码6个条件,6个真值结果?_百度...答:=IF(A1>1,IF(B2="左侧一对",(A3-A1-50)/2,A3-A1-50-3),IF(A1=0,IF(B2="左侧一对",(A3-A1-3)/2,A3-A1-3),0))