excel中如何用函数说明大于等于60小于70为D,大于等于70小于80为C,大于...答:假设成绩在A1,用公式:(小于60为E)=IF(A1<60,"E",IF(A1<70,"D",IF(A1<80,"C",IF(A1<90,"B","A")))
Excel数据处理中IF函数最常见用法答:=IF(D3>=85,"优秀",IF(D3>=70,"良好",IF(D3>=60,"合格","不合格")))注:在做条件判断是可以有大于,大于等于,小于,小于等于,等于 ,不等于,用符号表示分别为:>, >= , < , <= , =,<>。3、复杂条件使用:判断是否完成任务,出货量大于等于800,且库存量小于100,为完成任务...