在C2插入=IF(AND(A2="A",OR(B2=1,B2=2)),1,"")或=IF(AND(A2="A",B2<>3),1,"") （要求b列取值只为1，2,3三个可能）
=IF(AND(C1=A1,OR(B1=1,B1=2)),1,"")
c2=if(and(a2="A",or(b2=1,b2=2)),1,"")
