EXCEL成绩等级表怎么划分优良中差四个等级

EXCEL2003 具体一点吧
2024-11-19 02:49:09
推荐回答(2个)
回答1:

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

回答2:

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