你条件有矛盾,7符合又不符合.=IF(OR(A1={1,4,7,8,9,10}),"符合",IF(OR(A1={3,2,5,6,13}),"不符合",""))
=IF(OR(A1=1,A1=4,A1=7,A1=8,A1=9,A1=10),"符合",IF(OR(A1=3,A1=2,A1=5,A1=6,A1=7,A1=13),"不符合","")
