数值在“成绩”100~89为优秀80~89为良好70~79为中等60~69为及格不到60为不及格
公式为下列公式之一
=IF(A2>=89,"优秀",IF(A2>=80,"良好",IF(A2>=70,"中等",IF(A2>=60,"及格","不及格"))))
=IF(A2<60,"不及格",IF(A2<70,"及格",IF(A2<80,"中等",IF(A2<90,"良好","优秀"))))
=IF(A2="","",LOOKUP(A2,{0,60,70,80,89},{"不及格","及格","中等","良好","优秀"}))
下拉填充
条件格式设置如下:
或
公式为这个:=VLOOKUP(A6,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2,1)
条件格式的设置如图所示,