L2单元格输入公式=IF(K2<60,"不及格",IF(K2<70,"及格",IF(K2<80,"中等",IF(K2<90,"良好","优秀"))))或=VLOOKUP(K2,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2)再或=LOOKUP(K2,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"})下拉复制公式
