wenshi12
幼苗
共回答了12个问题采纳率:91.7% 举报
B2输入
=IF(OR(AND(A1=1,OR(A2={0,1,2,5,6,7})),AND(A1=2,OR(2={1,2,3,6,7,8})),AND(A1=3,OR(A2={2,3,4,7,8,9})),AND(A1=4,OR(A2={3,4,5,8,9,0})),AND(A1=5,OR(A2={4,5,6,9,0,1})),AND(A1=6,OR(A2={5,6,7,0,1,2})),AND(A1=7,OR(A2={6,7,8,1,2,3})),AND(A1=8,OR(A2={7,8,9,2,3,4})),AND(A1=9,OR(A2={8,9,0,3,4,5})),AND(A1=0,OR(A2={9,0,1,4,5,6}))),"对","")
回车。
1年前
8