excel工作表中添加每位学生语、数、英、科成绩的等级优秀、良好、合格、不合格

优秀、良好、合格、不合格，输入一次。按alt+上下方向键完成快速输入

K2=IF(E2>=INDIRECT("成绩分析!D"&LEFT($B2)+5),"优秀",IF(E2>=INDIRECT("成绩分析!E"&LEFT($B2)+5),"良好",IF(E2>=60,"合格","不合格")))

L2=IF(F2>=INDIRECT("成绩分析!H"&LEFT($B2)+5),"优秀",IF(F2>=INDIRECT("成绩分析!I"&LEFT($B2)+5),"良好",IF(F2>=60,"合格","不合格")))

M2=IF(G2>=INDIRECT("成绩分析!L"&LEFT($B2)+5),"优秀",IF(G2>=INDIRECT("成绩分析!M"&LEFT($B2)+5),"良好",IF(G2>=60,"合格","不合格")))

N2=IF(H2>=INDIRECT("成绩分析!P"&LEFT($B2)+5),"优秀",IF(H2>=INDIRECT("成绩分析!Q"&LEFT($B2)+5),"良好",IF(H2>=60,"合格","不合格")))

假设，C2是学生语文的标题，从C3开始向下是每位同学的语文成绩。在D3单元格中输入“=if(c2>=85,"优秀",if(c2>=70,"良好"，if(c2>=60,"合格","不合格")))”
重新选中D3单元格，将鼠标放到D3单元格的右下方，当鼠标指针变成“+”时，