按条件显示对应内容

Justin-2016

求助按指定条件显示结果.zip (9.16 KB, 下载次数: 23)

2024-6-19 13:39 上传

点击文件名下载附件

糖↗小冷

=IF(AND(AG6="",AR6="",BH6="",BK6="",BL6="",BM6=""),"MZ（C)",IF(AND(OR(AG6<>"",AG6="KG",AG6="有"),AR6=""),"MB（C)",IF(AND(AR6<>"",AG6=""),"MZ（MB)",IF(AND(AG6<>"",AR6<>"",BH6=""),"MB",IF(AND(AG6<>"",BH6<>"",AR6<>"",BJ6<>"",BK6=""),"CT",IF(AND(BH6<>"",AR6<>"",BH6<>"",BJ6=""),"CT+ZP",IF(AND(BL6<>"",BM6=""),"CYB",IF(BM6<>"","TSWC"))))))))

Justin-2016

糖↗小冷 发表于 2024-6-19 15:17
=IF(AND(AG6="",AR6="",BH6="",BK6="",BL6="",BM6=""),"MZ（C)",IF(AND(OR(AG6"",AG6="KG",AG6="有"),AR6=" ...

公式达到了模拟数据效果，但如果判断列出现非日期、“有”、“KG”时结果就不正确了，比如条件判断列如果出现“/”或“待查”等模拟数据里没有的非空单元格时，结果就不对了。