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

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/05 19:43:22
excel函数,把=IF(K2=

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