EXCEL使用来自if函数嵌套超过七层怎么办

EXCEL使用来自if函数嵌套超过七层怎么办

问题补充说明：我自己列的公式是=if(P6<49,"F",if(P6<=52,"D",if(P6<=57,"C-",if(P6<=62, "C",if(P6<=67,"C+",if(P6<=71, "B-",if(P6<=77, "B",if(P6<=82,"B+",if(P6<=87, "A-",if(P6<=92, "A",if(P6<=100,"A+")))))))))))但因为超过七层，不允许使用。应该怎么列呢？老师要求一定要if的函数表达。。

你写的公式数据与表格中的数据不对应

公式可以写成

=IF(P360问答6="","",LOOK急送意可总杨领UP(P6,{0,"F";50,"D";53,"C-";58,"C";63,"C+";68,"B-";72,"B";78,"B+";83,"A益音半你多革措山汉县-";88,"A";93,"A+"}))

07及以上的版本可以支持7层以上的足均但延房划晚沿海减嵌套,如果是03版且一定要用IF进行嵌套的话,公式可以改成

=IF(P6="","",IF(P6<72,IF钱花油型落永(P6<50,"F",IF(P6<53,"D",IF(P6<58,"C-",IF(P6<63,"C",IF(P6<68,"C+","B跟穿复犯争巴顶输铁-"))))),IF(P6<78,"B",IF(P6<83,"B+",IF(P6<88,"A-",IF(P6<93,"A","A+"))))))