EXCEL表格函数的关于——“IF三个条件分别对应三个结果的公式,请高人...答:B1输入 =VLOOKUP(A1,{1,"通过";2,"拒绝";3,"待定"},2,0)或者输入 =LOOKUP(A1,{1,2,3},{"通过","拒绝","待定"})条件可以任意多个。
excel中if函数怎么用有多个条件,多个结果答:1、首先打开excel表格,输入学生姓名和成绩,设置等级列。2、接着在等级列中,输入条件语句=(IF(B2>=90,"优秀",IF(B2>=80,"良好",IF(B2>=70,"中等",IF(B2>=60,"及格",IF(B2<60,"不及格"))),回车得到等级结果。3、然后在第一个等级单元格右下角下拉填充公式。4、填充完成后,如下图...
EXCEL里面IF函数,今天减去交货日期,有3个条件,需要给3个值答:公式为:=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","剩余3天以上"))=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","还剩"&A2-TODAY()&"天"))如图所示:
if函数3个条件3个结果答:如图例:C2=B2*IF(COUNT(FIND({"实习生","试用期"},A2)),3,IF(COUNT(FIND("客服",A2)),IF(B2<10000,4,6),IF(B2<10000,7,10)))