假如分数在A1单元格B1输入=IF(A1>=85,"优秀",IF(A1<60,"不及格","合格"))
=IF(A1>=85,"优秀",IF(A1>=60,"合格","不及格"))
=IF(A1>=85,"优秀",IF(A1>=60,"及格","不及格"))