假设你的表格中成绩在A1单元格中，则在另一单元格中插入公式：=IF(A1>=60,IF(A1<90,IF(A1<80,IF(A1<70,"合格","良好"),"优秀"),"最好"),"不合格")
=if(a1>90,“最好",if(a1>80,"优秀",if(a1>60,"良好","合格")))
61算合格还是算良好？60算什么？
