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/06/30 23:37:24
![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)),](/uploads/image/z/1629265-49-5.jpg?t=EXCEL%E5%85%AC%E5%BC%8F%E5%A4%AA%E9%95%BF%E6%80%8E%E4%B9%88%E5%8A%9E%3DIF%28OR%28AND%28%24DP5%3D1%2CDQ5%3D1%29%2CAND%28%24DP5%3D2%2CDQ5%3D2%29%2CAND%28%24DP5%3D3%2CDQ5%3D3%29%2CAND%28%24DP5%3D4%2CDQ5%3D4%29%2CAND%28%24DP5%3D5%2CDQ5%3D5%29%2CAND%28%24DP5%3D6%2CDQ5%3D6%29%2CAND%28%24DP5%3D7%2CDQ5%3D7%29%2CAND%28%24DP5%3D8%2CDQ5%3D8%29%29%2C%221%22%2CIF%28OR%28AND%28%24DP5%3D1%2CDQ5%3D2%29%2CAND%28%24DP5%3D2%2CDQ5%3D1%29%2CAND%28%24DP5%3D3%2CDQ5%3D4%29%2CAND%28%24DP5)
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)