第1个回答 2017-05-23
=IF(A1>=281,C,IF(A1>=181,B,IF(A1>=1,A,X)))
第2个回答 2017-05-23
=IF(AND(A1>1,A1<180),"a",IF(and(a1>181,a1<280),"b",if(a1>280,"C","")))
这样写,你自己都看懂了。本回答被提问者采纳
第3个回答 2017-05-23
=if(and(a1>1,a1<=180),"A",if(and(a1>181,a1<=280),"B",if(a1>=281,"C","X")))
第4个回答 2017-05-23
=IF(A1>=281,"C",IF(A1>=181,"B",IF(A1>=1,"A","X")))