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",...
excle中,有关if函数,or函数,find函数的运用。答:W2=IF(COUNT(1/FIND({"货物","贸易"},V2)),1,"")如果你要套用ISNUMBER函数也可以:=IF(SUM(--ISNUMBER(FIND({"货物","贸易"},V2))),1,"")