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中如何确定三个条件满足2个答:0,LEFT(c2,1)*IF(MID(c2,2,1)="A",100,IF(MID(c2,2,1)="P",10,1))+MID(c2,3,1)*IF(MID(c2,4,1)="A",100,IF(MID(c2,4,1)="P",10,1)))<=41,IF(ISERROR(LEFT(d2,1)*IF(MID(d2,2,1)="A",100,IF(MID(d2,2,1)="P",10,1))+MID(d2,3,1)*IF(MID...
excel中if函数怎么用有多个条件,多个结果答:1、首先打开excel表格,输入学生姓名和成绩,设置等级列。2、接着在等级列中,输入条件语句=(IF(B2>=90,"优秀",IF(B2>=80,"良好",IF(B2>=70,"中等",IF(B2>=60,"及格",IF(B2<60,"不及格"))),回车得到等级结果。3、然后在第一个等级单元格右下角下拉填充公式。4、填充完成后,如下图...