EXCEL中用函数分等级答:最简单的是用if函数:=if(a1<60,"不及格",if(a1<75,"中等",if(a1<85,"良好","优秀")))此外也可以用lookup函数:=lookup(a1,{0,60,75,85},{"不及格","中等","良好","优秀"})
excel,给了几个学生的平均成绩,按此成绩排等级,用IF函数该如何输入?平 ...答:1、如果成绩在B列,在C列对成绩进行评级,那么在C2输入以下公式,然后向下填充公式 =IF(B2<60,"不及格",IF(B2<70,"及格",IF(B2<80,"中",IF(B2<90,"良","优")))2、统计C列优的个数,输入=COUNTIF(C:C,"优")