=lookup(各科成绩表!C3,{0,70,80,90},{"差","中等","良好","优秀"})
=if(各科成绩表!c3>=90,"优秀",if(各科成绩表!c3>=80,"良好",if(各科成绩表!c3>=70,"中等","一般")))