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/12/31 01:15:34
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")))))))
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
按你公式的结构,可以简化成
=IF(DQ5=INDEX({1,2,3,4,5,6,7,8},$DP5),"1",IF(DQ5=INDEX({2,1,4,3,6,5,8,7},$DP5),"2",IF(DQ5=INDEX({3,4,1,2,7,8,5,6},$DP5),"3",IF(DQ5=INDEX({4,3,2,1,8,7,6,5},$DP5),"4",IF(DQ5=INDEX({5,6,7,8,1,2,3,4},$DP5),"5",IF(DQ5=INDEX({6,5,8,7,2,1,4,3},$DP5),"6",IF(DQ5=INDEX({7,8,5,6,3,4,1,28},$DP5),"7","8")))))))
如果是2007版,还可以简化成
=IFERROR(MATCH(DQ5,CHOOSE($DP5,{1,2,3,4,5,6,7},{2,1,4,3,6,5,8},{3,4,1,2,7,8,5},{4,3,2,1,8,7,6},{5,6,7,8,1,2,3},{6,5,8,7,2,1,4},{7,8,5,6,3,4,1},{8,7,6,5,4,3,28}),),8)