EXCEL中用函数分等级
发布网友
共3个回答
热心网友
最简单的是用if函数：
=if(a1<60,"不及格",if(a1<75,"中等",if(a1<85,"良好","优秀")))
此外也可以用lookup函数：
=lookup(a1,{0,60,75,85},{"不及格","中等","良好","优秀"})
热心网友
=IF(A1>=85,"优秀",=IF(A1>=75,"良好",=IF(A1>=60,"中等","不及格")))
热心网友
用if语句嵌套就可以搞定了
if(A1＜60,“不及格”,if(and(60<=A1,A1＜75),“中等”,if(And(A1>=75,A1<85),“良好”,“优秀”)
