excel函数,把=IF(K2="","未考试i","") 与=IF(B2="",IF(OR(C2"",D2""),"缺

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/21 22:04:43

excel函数,把=IF(K2="","未考试i","") 与=IF(B2="",IF(OR(C2"",D2""),"缺名字"),"")组合在一起

=IF(K2="","未考试i","") &IF(B2="",IF(OR(C2"",D2""),"缺名字"),"")