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))...
excel表的公式表达大于小于答:IF(A1>10000,0.1,IF(A1>=5001,0.4,IF(A1>=2001,0.8,IF(A1>=1001,1.5,IF(A1>=201,2,IF(A1>=101,3,4)))以下是我之前的一个回答,可参考
Excel的if函数,如果A1大于50000,小于60000,则B1等于100,A1大于60000...答:在B2输入函数:=IF(AND(A2>50000,A2<60000),100,IF(AND(A2>60000,A2<70000),200,""))就可以了,往下填充公式,还可以判断其他A列的数值。