求EXCEL一函数。

来源：百度知道编辑：UC知道时间：2024/05/29 01:42:55

如果A1列数值=61-70之间，在B1显示D
如果A2列数值=71-80之间，在B2显示C
如果A3列数值=81-90之间，在B3显示B
如果A4列数值=91-100之间，在B4显示A

在B1输入=IF(AND(A1>=61,A1<=70),"D",IF(AND(A1>=71,A1<=80),"C",IF(AND(A1>=81,A1<=90),"B",IF(AND(A1>=91,A1<=100),"A",""))))
然后往下填充

B1=IF(A1<=61,"",IF(A1<70,"D", ""))
B2=IF(A2<=71,"",IF(A2<80,"C", ""))
B3=IF(A3<=81,"",IF(A3<90,"B", ""))
B4=IF(A4<=91,"",IF(A4<100,"A", ""))