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函数怎么用 ,如果A1表内大于等于100 B1表格就等于529 如果A1...答:; 如果A1表内大于200小于等于300 B1就等于399 ; 如果A1表内大于300小于等于400 B1就等于499 这样吧??如果这样,公式接着:=if(A1<=100,529,if(A1<=200,299,if(A1<=300,399,if(A1<=400,499,"")))或者 =if(A1>=400,"",choose(roundup(a1/100,0),529,299,399,499))...