excel中IF公式多条件公式求助

发布网友发布时间：2024-10-22 04:45

共1个回答

热心网友时间：2024-11-08 21:12

源数据在A2，在B2输入
=IF(A2<60,"D",IF(A2<=65,"C",IF(A2<=69,"B-",IF(A2<=74,"B",IF(A2<=85,"A-",IF(A2<=90,"A",IF(A2<="A+","S")))))))
或
=LOOKUP(A2,{0,60,66,70,80,86,91,96},{"D","C","B-","B","A-","A","A+","S"})
回车。

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com