第1个回答 2012-10-08
选择A11
粘贴公式 =IF(SUM(IF(A1:A10="a",0,IF(A1:A10="b",0,1)))=0,0,1)
按下F2,然后用CTRL+SHIFT+回车
第2个回答 2012-10-08
=IF(COUNTIF(A1:A10,"a")+COUNTIF(A1:A10,"b")=10,0,1)
追问这个有限制,只能是你确定有多少个单元格才行,我要求的是不确定数量的哦
追答=IF(COUNTIF(A1:A10,"a")+COUNTIF(A1:A10,"b")=COUNTA(A1:A10),0,1)
本回答被提问者采纳
第3个回答 2012-10-08
=1-(COUNTIF(A1:A10,"a")+COUNTIF(A1:A10,"b")=ROWS(A1:A10))
或
=if(COUNTIF(A1:A10,"a")+COUNTIF(A1:A10,"b")=ROWS(A1:A10),0,1)
第4个回答 2012-10-08
=IF(COUNTIF(A1:A10,"<>a")+COUNTIF(A1:A10,"<>b")-COUNTIF(A1:A10,"a")-COUNTIF(A1:A10,"b")-COUNTBLANK(A1:A10)*2>0,1,0)
第5个回答 2012-10-08
在a列中任一位置输入下列公式(除A1外):
=IF(SUMPRODUCT(--(INDIRECT("r1c:r[-1]c",)={"a","b"}))=COUNTA(INDIRECT("r1c:r[-1]c",)),,1)