excel 里用函数判断成绩等级,平均分>=60为合格,70为中等 80为优秀,怎 ...答:假设优秀、良好,中等,及格在A列,在B列里输入:=IF(A2="优秀",90,IF(A2="良好",80,IF(A2="中等",70,IF(A2="及格",60,"")))引用完成后,将B列的值剪切并粘到A列,选择性粘贴---粘贴值。一定要粘贴值!!...黑龙江省 张志晨...热心相助...共同提高......
excel中用函数、条件格式填充“总评等级”并使不及格为红色答:公式为下列公式之一 =IF(A2>=89,"优秀",IF(A2>=80,"良好",IF(A2>=70,"中等",IF(A2>=60,"及格","不及格")))=IF(A2<60,"不及格",IF(A2<70,"及格",IF(A2<80,"中等",IF(A2<90,"良好","优秀")))=IF(A2="","",LOOKUP(A2,{0,60,70,80,89},{"不及格","及格","中等...