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

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/01 08:08:08

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""),"缺名字"),"")