excel里面if条件的设定

显示全部楼层 · 2013-7-8 22:09:14

如果D列和F列的单元格中都不为空值，那么在G2中输入函数：=IF(AND(D2"未报名",F2"未报名"),"正副卡都报名",IF(AND(D2="未报名",F2="未报名"),"正副卡均未报名",IF(D2="未报名","副卡已报名","正卡已报名")))如果有空值，在条件and()函数中，加入条件D2"",F2""...

千问 · 2013-7-8 22:09:14

=if(And(C2="未报名",F2="未报名"),"均未报名",if(C2="未报名","副卡已报名",if(F2="未报名","正卡已报名","正副卡都报名")))即可...

千问 · 2013-7-8 22:09:14

G2:=IF(AND(D2"未报名",F2"未报名"),"正副卡已报名",IF(D2"未报名","正卡已报名",IF(F2"未报名","副卡已报名",)))...