excel条件函数判断

两个关联条件。B2输入=IF(OR(AND(OR(A1={2,3,4,5,6}),OR(A2={9,10,1})),AND(OR(A1={7,8,9,10,1}),OR(A2={2,3,4}))),"错","对")回车并向下填充。