函数参数过多是什么意思，怎么解决？

=IF(M7=30,"满分",IF(M7>=27,M7<=29,"优",IF(M7>=23,M7<=26,"良",IF(M7>=20,M7<=22,"一般",IF(M7<22,"加油")))))

最新回答

野稚

2024-09-05 03:07:52

你的公式表达犯了严重错误，比如可能是想表达当M7大于等于27小于等于29就为优，用的公式IF(M7>=27,M7<=29,"优" 是不对的，应该这样表达IF(and(M7>=27,M7<=29),"优"
另外，用IF语句一定要理清逻辑关系，优化公式，你的公式其实可以这样=IF(M7=30,"满分",IF(M7>=27,"优",IF(M7>=23,"良",IF(M7>=20,"一般","加油"))))

青柠之恋

2024-09-05 10:36:01

=IF(M7=30,"满分",IF(AND(M7>=27,M7<=29),"优",IF(AND(M7>=23,M7<=26),"良",IF(AND(M7>=20,M7<=22),"一般",IF(M7<20,"加油")))))
或者

=IF(M7<20,"加油",IF(M7<=22,"一般",IF(M7<=26,"良",IF(M7<=29,"优",IF(M7=30,"满分","")))))

夜巴黎

2024-09-05 02:29:51

公式为：
=IF(M7<20,"加油",IF(M7<22,"一般", IF(M7<27,"良",IF(M7<30, "优","满分"))))
或者是：
=LOOKUP(M7,{0,20,22,27,29},{"加油","一般","良","优","满分"})

我要回答

匿名回答

函数参数过多是什么意思，怎么解决？

您可能感兴趣问答

Collapsible

热门标签

热点问答