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

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/26 08:49:25
excel函数,把=IF(K2="","未考试i","")与=IF(B2="",IF(OR(C2"",D2""),"缺名字"),"")组合在一起excel函数,把=IF(K2="","未考试i",""

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

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