两种结果叠加

123mjh · 发表于 2023-5-15 12:39

本帖最后由 123mjh 于 2023-5-15 14:47 编辑

请看附件谢谢

无聊的黑猫 · 发表于 2023-5-15 13:31

=CHOOSE(MATCH((MATCH(CONCAT((((B5-D5)&(D5-F5))=((B5-E5)&(E5-F5)))*1,(((B5-D5)&(D5-F5))=((B5-C5)&(C5-F5)))*1,(((B5-E5)&(E5-F5))=((B5-C5)&(C5-F5)))*1),{"100","010","001","110","000"},0)-1)&(MATCH(CONCAT((((B5-D5)-(D5-F5))=((B5-E5)-(E5-F5)))*1,(((B5-D5)-(D5-F5))=((B5-C5)-(C5-F5)))*1,(((B5-E5)-(E5-F5))=((B5-C5)-(C5-F5)))*1),{"100","010","001","110","000"},0)-1),{"00","11","33","44","40","41","42","03","13"},0),0,1,3,4,8,8,8,2,2)

123mjh · 发表于 2023-5-15 14:44

无聊的黑猫发表于 2023-5-15 13:31
=CHOOSE(MATCH((MATCH(CONCAT((((B5-D5)&(D5-F5))=((B5-E5)&(E5-F5)))*1,(((B5-D5)&(D5-F5))=((B5-C5)&(C ...

公式结果不对呢？

		自动登录	找回密码
密码			免费注册

[已解决] 两种结果叠加