EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式

C1单元格写入公式
=IF(OR(A1="",B1=""),"",CHOOSE(A1+1,IF(OR(B1={7,8,9,0,1,2,3}),"正确",""),IF(OR(B1={8,9,0,1,2,3,4}),"正确",""),IF(OR(B1={9,0,1,2,3,4,5}),"正确",""),IF(OR(B1={0,1,2,3,4,5,6}),"正确",""),IF(OR(B1={1,2,3,4,5,6,7}),"正确",""),IF(OR(B1={2,3,4,5,6,7,8}),"正确",""),IF(OR(B1={3,4,5,6,7,8,9}),"正确",""),IF(OR(B1={4,5,6,7,8,9,0}),"正确",""),IF(OR(B1={5,6,7,8,9,0,1}),"正确",""),IF(OR(B1={6,7,8,9,0,1,2}),"正确","")))
再简写一下
=IF(OR(A1="",B1=""),"",IF(CHOOSE(A1+1,OR(B1={7,8,9,0,1,2,3}),OR(B1={8,9,0,1,2,3,4}),OR(B1={9,0,1,2,3,4,5}),OR(B1={0,1,2,3,4,5,6}),OR(B1={1,2,3,4,5,6,7}),OR(B1={2,3,4,5,6,7,8}),OR(B1={3,4,5,6,7,8,9}),OR(B1={4,5,6,7,8,9,0}),OR(B1={5,6,7,8,9,0,1}),OR(B1={6,7,8,9,0,1,2})),"正确",""))
又想了一下,公式改成
=IF(OR(A1="",B1=""),"",IF(AND(AND(A1>=0,A1