=IF(OR(AND(C2=0,E2=0),AND(C2=1,E2=1),AND(C2=2,E2=2),AND(C2=3,E2=3),AND(C2=4,E2=4),AND(C2=5,E2=5),AND(C2=6,E2=6),AND(C2=7,E2=7),AND(C2=8,E2=8),AND(C2=9,E2=9),OR(AND(C2=0,F2=0),AND(C2=1,F2=1),AND(C2=2,F2=2),AND(C2=3,F2=3),AND(C2=4,F2=4),AND(C2=5,F2=5),AND(C2=6,F2=6),AND(C2=7,F2=7),AND(C2=8,F2=8),AND(C2=9,F2=9),OR(AND(C2=0,G2=0),AND(C2=1,G2=1),AND(C2=2,G2=2),AND(C2=3,G2=3),AND(C2=4,G2=4),AND(C2=5,G2=5),AND(C2=6,G2=6),AND(C2=7,G2=7),AND(C2=8,G2=8),AND(C2=9,G2=9),OR(AND(C2=0,H2=0),AND(C2=1,H2=1),AND(C2=2,H2=2),AND(C2=3,H2=3),AND(C2=4,H2=4),AND(C2=5,H2=5),AND(C2=6,H2=6),AND(C2=7,H2=7),AND(C2=8,H2=8),AND(C2=9,H2=9))))),"错","对") 这个公式写到AND(C2=7,H2=7)这里就写不了啦，Excel提示公式太长。请问能直接简化这个公式吗？
飞驰的胖子
