第1个回答 2013-03-30
用IF,C1中公式如下
=IF(AND(A1<1,B1<1),"A",IF(AND(A1>1,B1<1),"C",IF(AND(A1>1,B1>1),"D","")))本回答被提问者采纳
第2个回答 2013-03-30
多条件判断的都是使用if函数来解决的在C1输入=IF(AND(A1<1,B1<1),"A",IF(AND(A1>1,B1<1),"B",IF(AND(A1<1,B1>1),"C",IF(AND(A1>1,B1>1),"D",""))))
第3个回答 2013-03-30
=if(a1<1,if(b1<1,"A","C"),if(b1<1,"B","D"))