求助公式

5698d

请看附件  谢谢
H5 公式 =MIN(ABS(B5:D5-D5:F5))  错哪里了？               



错在 没加大括弧

安若浅笑

附件为何会打不开

安若浅笑

手机上下载的压缩文件打不开，是需要下载其它APP吗

5698d

安若浅笑 发表于 2023-3-19 08:02
手机上下载的压缩文件打不开，是需要下载其它APP吗

手机不清楚啊

5698d

安若浅笑 发表于 2023-3-19 08:00
附件为何会打不开

用电脑也无法下载么？

5698d

原来公式可以辣么长
=IF(A5="","",VALUE(IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="1000","3",IF(IF(G5=MIN(G5:J5),0,IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0100","4",&IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0010","5",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0001","6",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="1100","1",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0110","1",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0011","1",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="0101","2",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="1001","2",IF(IF(G5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(G5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(H5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(H5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(I5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(I5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))&IF(J5=MIN(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,IF(J5=MAX(ABS(B5-C5),ABS(C5-D5),ABS(D5-E5),ABS(E5-F5)),0,1))="1010","2",IF(ABS(B5-C5)&ABS(C5-D5)&ABS(D5-E5)&ABS(E5-F5)="0000","7",IF(ABS(B5-C5)&ABS(C5-D5)&ABS(D5-E5)&ABS(E5-F5)="1111","7",IF(ABS(B5-C5)&ABS(C5-D5)&ABS(D5-E5)&ABS(E5-F5)="2222","7","9")))))))))))))))

良良

楼主题出的有问题吧？
如B505:F505，由=ABS(B505:E505-C505:F505)可得：{1,1,0,2}，即一 、二 、三、 四的值是3个不同。去掉最小值和最大值后，中间值是两个1，既是一、又是二，该显示3呢？还是显示4？

5698d

良良 发表于 2023-3-19 15:59
楼主题出的有问题吧？
如B505:F505，由=ABS(B505:E505-C505:F505)可得：{1,1,0,2}，即一 、二 、三、 四的 ...

：{1,1,0,2}，    1 1是中间值在  B-C 和C-D  顾显示 1

5698d

良良 发表于 2023-3-19 15:59
楼主题出的有问题吧？
如B505:F505，由=ABS(B505:E505-C505:F505)可得：{1,1,0,2}，即一 、二 、三、 四的 ...

百密一疏啊，请不要考虑几个号的问题了，附件已更新，请重新下载

5698d

早   上   好