在EXCEL如何用IF函数写下面的条件,请各位高手指点一下。 谢谢 !!在线等

2024-12-25 16:39:40
推荐回答(3个)
回答1:

=IF(C11>=90,"优秀",IF(AND(C11>=80,C11<90),"良好",IF(AND(C11>=70,C11<80),"中等","及格")))

回答2:

=if(B1>=90,"优秀",if(B1>=80,"良好",if(B1>=70,"中等","")

回答3:

=LOOKUP(A1,{70,80,90},{"中等","良好","优秀"})