=if(and(a1=1,or(b1={2,3,4})),"真","假")
B1的公式这样写就行=IF(AND(A1=1,OR(A2=2,A2=3,A2=4)),TRUE,FALSE) 追加问题的回答=IF(AND(OR(A1={1,3,5,7}),OR(A2={2,3,4})),TRUE,FALSE)
