关于Excel的if

来源：百度知道 编辑：UC知道 时间：2024/06/30 15:40:21
得分>=90，则为“优”；80=<总分<90，则为“良”，70=<总分<80，则为“中”60=<总分<70，则为“及格”，总分<60，则为“不及格”
求高手帮忙，谢谢啦

假设 分数在C列，评级在D列
在D2单元格内输入
=if(c2>89.9,"优",if(c2>79.9,"良",if(c2>69.9,"中",if(c2>59.9,"及格","不及格"))))
回车

=if(c2>=90,"优",if(c2>=80,"良",if(c2>=70,"中",if(c2>=60,"及格","不及格"))))

=IF(A1>=80,IF(A1>=90,"优","良"),IF(A1>=60,IF(A1>=70,"中","及格"),"不及格"))

假设分数是在D列，从D2单元格开始向下是要计算的分数，在D2后面相对应的单元格中输入，=if(D2>=90,"优",if(D2>=80,"良",if(D2>=70,"中",if(D2>=60,"及格","不及格"))))
或者
=if(D2<60,"不及格",if(D2<70,"及格",if(D2<80,"中",if(D2<90,"良","优"))))