=IF(AND(B4<>"",D4"" ),未考试，IF(AND(D4<>"",B4""),缺姓名,))，office2007的excel，“

Question

"如果有学生姓名（B4)但是无考试成绩D4。则显示未考试F4；如果有考试成绩或平时成绩但无姓名，则显示缺姓名“。如果没有姓名也无考试成绩，则总评成绩和备注均无记录。"什么公式有什么问题

Answer 1

F4中输入公式
=if(and(b4<>"",d4=""),"未考试",if(and(b4="",d4<>""),"缺姓名",if(and(b4="",d4=""),"","有姓名也有成绩的结果")))

Answer 2

=IF(AND(B4<>"",D4=""),未考试,IF(AND(D4<>"",B4=""),缺姓名,))

Answer 3

=IF(AND(B4<>"",D4="" ),"未考试",IF(AND(D4<>"",B4=""),"缺姓名",""))