EXCEL公式太长怎么办=IF(OR(AND($DP5=1,DQ5=1),AND($DP5=2,DQ5=2),AND($DP5=3,DQ5=3),AND($DP5=4,DQ5=4),AND($DP5=5,DQ5=5),AND($DP5=6,DQ5=6),AND($DP5=7,DQ5=7),AND($DP5=8,DQ5=8)),"1",IF(OR(AND($DP5=1,DQ5=2),AND($DP5=2,DQ5=1),AND($DP5=3,DQ5=4),AND($DP5

来源：学生作业帮助网编辑：作业帮时间：2024/05/02 19:43:09

EXCEL公式太长怎么办=IF(OR(AND($DP5=1,DQ5=1),AND($DP5=2,DQ5=2),AND($DP5=3,DQ5=3),AND($DP5=4,DQ5=4),AND($DP5=5,DQ5=5),AND($DP5=6,DQ5=6),AND($DP5=7,DQ5=7),AND($DP5=8,DQ5=8)),"1",IF(OR(AND($DP5=1,DQ5=2),AND($DP5=2,DQ5=1),AND($DP5=3,DQ5=4),AND($DP5
EXCEL公式太长怎么办
=IF(OR(AND($DP5=1,DQ5=1),AND($DP5=2,DQ5=2),AND($DP5=3,DQ5=3),AND($DP5=4,DQ5=4),AND($DP5=5,DQ5=5),AND($DP5=6,DQ5=6),AND($DP5=7,DQ5=7),AND($DP5=8,DQ5=8)),"1",IF(OR(AND($DP5=1,DQ5=2),AND($DP5=2,DQ5=1),AND($DP5=3,DQ5=4),AND($DP5=4,DQ5=3),AND($DP5=5,DQ5=6),AND($DP5=6,DQ5=5),AND($DP5=7,DQ5=8),AND($DP5=8,DQ5=7)),"2",IF(OR(AND($DP5=1,DQ5=3),AND($DP5=2,DQ5=4),AND($DP5=3,DQ5=1),AND($DP5=4,DQ5=2),AND($DP5=5,DQ5=7),AND($DP5=6,DQ5=8),AND($DP5=7,DQ5=5),AND($DP5=8,DQ5=6)),"3",IF(OR(AND($DP5=1,DQ5=4),AND($DP5=2,DQ5=3),AND($DP5=3,DQ5=2),AND($DP5=4,DQ5=1),AND($DP5=5,DQ5=8),AND($DP5=6,DQ5=7),AND($DP5=7,DQ5=6),AND($DP5=8,DQ5=5)),"4",IF(OR(AND($DP5=1,DQ5=5),AND($DP5=2,DQ5=6),AND($DP5=3,DQ5=7),AND($DP5=4,DQ5=8),AND($DP5=5,DQ5=1),AND($DP5=6,DQ5=2),AND($DP5=3,DQ5=3),AND($DP5=8,DQ5=4)),"5",IF(OR(AND($DP5=1,DQ5=6),AND($DP5=2,DQ5=5),AND($DP5=3,DQ5=8),AND($DP5=4,DQ5=7),AND($DP5=5,DQ5=2),AND($DP5=6,DQ5=1),AND($DP5=7,DQ5=4),AND($DP5=8,DQ5=3)),"6",IF(OR(AND($DP5=1,DQ5=7),AND($DP5=2,DQ5=8),AND($DP5=3,DQ5=5),AND($DP5=4,DQ5=6),AND($DP5=5,DQ5=3),AND($DP5=6,DQ5=4),AND($DP5=7,DQ5=1),AND($DP5=8,DQ5=28)),"7","8")))))))