excel函数if公式怎么嵌套超过7层啊大家帮忙我这个公式应该怎么才能设置成功啊=IF(AND(N4="一个月",O4="高",P4="配合"),"A",IF(AND(N4="一个月",O4="中",P4="配合"),"A",IF(AND(N4="一个月",O4="高",P4="配合"),"A",I
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 13:38:29
![excel函数if公式怎么嵌套超过7层啊大家帮忙我这个公式应该怎么才能设置成功啊=IF(AND(N4=](/uploads/image/z/2996905-49-5.jpg?t=excel%E5%87%BD%E6%95%B0if%E5%85%AC%E5%BC%8F%E6%80%8E%E4%B9%88%E5%B5%8C%E5%A5%97%E8%B6%85%E8%BF%877%E5%B1%82%E5%95%8A%E5%A4%A7%E5%AE%B6%E5%B8%AE%E5%BF%99%E6%88%91%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E5%BA%94%E8%AF%A5%E6%80%8E%E4%B9%88%E6%89%8D%E8%83%BD%E8%AE%BE%E7%BD%AE%E6%88%90%E5%8A%9F%E5%95%8A%3DIF%28AND%28N4%3D%22%E4%B8%80%E4%B8%AA%E6%9C%88%22%2CO4%3D%22%E9%AB%98%22%2CP4%3D%22%E9%85%8D%E5%90%88%22%29%2C%22A%22%2CIF%28AND%28N4%3D%22%E4%B8%80%E4%B8%AA%E6%9C%88%22%2CO4%3D%22%E4%B8%AD%22%2CP4%3D%22%E9%85%8D%E5%90%88%22%29%2C%22A%22%2CIF%28AND%28N4%3D%22%E4%B8%80%E4%B8%AA%E6%9C%88%22%2CO4%3D%22%E9%AB%98%22%2CP4%3D%22%E9%85%8D%E5%90%88%22%29%2C%22A%22%2CI)
excel函数if公式怎么嵌套超过7层啊大家帮忙我这个公式应该怎么才能设置成功啊=IF(AND(N4="一个月",O4="高",P4="配合"),"A",IF(AND(N4="一个月",O4="中",P4="配合"),"A",IF(AND(N4="一个月",O4="高",P4="配合"),"A",I
excel函数if公式怎么嵌套超过7层啊
大家帮忙我这个公式应该怎么才能设置成功啊
=IF(AND(N4="一个月",O4="高",P4="配合"),"A"
,IF(AND(N4="一个月",O4="中",P4="配合"),"A"
,IF(AND(N4="一个月",O4="高",P4="配合"),"A"
,IF(AND(N4="半年",O4="高",P4="配合"),"B"
,IF(AND(N4="三个月",O4="中",P4="配合"),"B"
,IF(AND(N4="一个月",O4="低",P4="配合"),"B"
,IF(AND(N4="三个月",O4="高",P4="不配合"),"B","")))))))&
,IF(AND(N4="三个月",O4="低",P4="配合"),"B"
,IF(AND(N4="三个月",O4="低",P4="配合"),"B"
,IF(AND(N4="一个月",O4="中",P4="不配合"),"B"
,IF(AND(N4="一个月",O4="高",P4="不配合"),"B"
,IF(AND(N4="半年",O4="中",P4="配合"),"B"
,IF(AND(N4="一个月",O4="低",P4="不配合"),"C"
,IF(AND(N4="三个月",O4="中",P4="不配合"),"C"
,IF(AND(N4="三个月",O4="低",P4="不配合"),"C","")))))))&
,IF(AND(N4="半年",O4="高",P4="不配合"),"C"
,IF(AND(N4="半年",O4="中",P4="不配合"),"C"
,IF(AND(N4="半年",O4="低",P4="配合"),"C"
,IF(AND(N4="半年",O4="低",P4="不配合"),"C"," ")))))
excel函数if公式怎么嵌套超过7层啊大家帮忙我这个公式应该怎么才能设置成功啊=IF(AND(N4="一个月",O4="高",P4="配合"),"A",IF(AND(N4="一个月",O4="中",P4="配合"),"A",IF(AND(N4="一个月",O4="高",P4="配合"),"A",I
=IF(AND(N4="一个月",O4="高",P4="配合"),"A"
,IF(AND(N4="一个月",O4="中",P4="配合"),"A"
,IF(AND(N4="一个月",O4="高",P4="配合"),"A"
,IF(AND(N4="半年",O4="高",P4="配合"),"B"
,IF(AND(N4="三个月",O4="中",P4="配合"),"B"
,IF(AND(N4="一个月",O4="低",P4="配合"),"B"
,IF(AND(N4="三个月",O4="高",P4="不配合"),"B","")))))))&
IF(AND(N4="三个月",O4="低",P4="配合"),"B"
,IF(AND(N4="三个月",O4="低",P4="配合"),"B"
,IF(AND(N4="一个月",O4="中",P4="不配合"),"B"
,IF(AND(N4="一个月",O4="高",P4="不配合"),"B"
,IF(AND(N4="半年",O4="中",P4="配合"),"B"
,IF(AND(N4="一个月",O4="低",P4="不配合"),"C"
,IF(AND(N4="三个月",O4="中",P4="不配合"),"C","")))))))&
IF(AND(N4="三个月",O4="低",P4="不配合"),"C"
,IF(AND(N4="半年",O4="高",P4="不配合"),"C"
,IF(AND(N4="半年",O4="中",P4="不配合"),"C"
,IF(AND(N4="半年",O4="低",P4="配合"),"C"
,IF(AND(N4="半年",O4="低",P4="不配合"),"C","")))))
“&”后面不要“,”,第二段超过7层.
其实公式还可精简,把N4的三种情况分开处理,就可以减少嵌套数.看到这么长的IF,有点烦!
重新组合精简后,可以不超过7层嵌套.
=IF(OR(N4="",O4="",P4=""),"",IF(N4="一个月",IF(P4="配合",IF(O4="低","B","A"),IF(O4="低","C","B")),IF(N4="三个月",IF(P4="配合",IF(O4="低","C","B"),IF(O4="高","B","C")),IF(P4="配合",IF(O4="低","C","B"),"C"))))