EXCEL IF 语句怎么嵌套的?答:=IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F"))) 给第二个成绩指定一个字母等级 (A)=IF(A4>89,"A",IF(A4>79,"B", IF(A4>69,"C",IF(A4>59,"D","F"))) 给第三个成绩指定一个字母等级 (C)在上例中,第二个 IF 语句同时也是第一个 IF 语句...
EXCEL中怎么操作啊。 45%一下,为0。45%-60%按续费额3%计算。60%-70%...答:假设判断对象在A1(如:45%在A1),续费额在B1,结果在C1,C1公式如下:=IF(A1<0.45,0,IF(AND(A1>=0.45,A1<0.6),B1*0.03,IF(AND(A1>=0.6,A1<0.7),B1*0.04,IF(AND(A1>=0.7,A1<0.8),B1*0.05,IF(A1>0.8,B1*0.06)))...