求助写个判断

不可说7625

quqiyuan 发表于 2024-3-11 22:32
=IF((ABS(A5-B5)=0)*(A5>=C5),A5-C5,IF((ABS(A5-B5)=0)*(A5=C5),IF(B5>C5,B5-C5,"")&(A5-C5)&IF(B5

这行应该是05

theking_wsz

=IF(MOD(A1-B1,5)=0,MOD(A1-C1,10)&IF(ABS(A1-B1)=5,MOD(B1-C1,10),""),"X")

天有多高999

=IF(OR(ABS(IMSUB(A1,B1))={0,5}),IF(A1<>B1,(B1<C1)*10+B1-C1,"")&(A1<C1)*10+A1-C1,"x")

quqiyuan

不可说7625 发表于 2024-3-11 22:35
这行应该是05

其实就是里面>、>=的问题
=IF((ABS(A1-B1)=0)*(A1>=C1),A1-C1,IF((ABS(A1-B1)=0)*(A1<C1),A1-C1+10,IF((ABS(A1-B1)=5)*(A1>=C1),IF(B1>=C1,B1-C1,"")&(A1-C1)&IF(B1<C1,B1-C1+10,""),IF((ABS(A1-B1)=5)*(A1<C1),IF(B1>=C1,B1-C1,"")&(A1-C1+10)&IF(B1<C1,B1-C1+10,""),"X"))))

hxj119

不可说7625 发表于 2024-3-11 22:17
绝对值等于5的时候，没有2个数字，

我再理一理，第2个的逻辑感觉没看也得明白，啥是两个结果相合！！

不可说7625

天有多高999 发表于 2024-3-11 22:38
=IF(OR(ABS(IMSUB(A1,B1))={0,5}),IF(A1B1,(B1

显示这个结果的能排下序吗？小到大

hxj119

参考公式：=IF(A1=B1,IF(A1<C1,A1+10-C1,A1-C1),IF(ABS(A1-B1)=5,MIN(IF(A1<C1,A1+10-C1,A1-C1),IF(B1<C1,B1+10-C1,B1-C1))&MAX(IF(A1<C1,A1+10-C1,A1-C1),IF(B1<C1,B1+10-C1,B1-C1)),"X"))

示例数据有点少，有待验证！

天有多高999

不可说7625 发表于 2024-3-11 22:51
显示这个结果的能排下序吗？小到大

=IF(OR(ABS(IMSUB(A1,B1))={0,5}),(MIN((A1<>B1)*((B1<C1)*10+B1-C1),(A1<C1)*10+A1-C1)&MAX((A1<>B1)*((B1<C1)*10+B1-C1),(A1<C1)*10+A1-C1))*1,"x")

啸海

=IF(A1=B1,A1+(A1<C1)*10-C1,IF(ABS(A1-B1)=5,(A1+(A1<C1)*10-C1)*10^((A1+(A1<=C1)*10-C1)<B1+(B1<C1)*10-C1)+(B1+(B1<C1)*10-C1)*10^((A1+(A1<C1)*10-C1)>B1+(B1<C1)*10-C1),"x"))


=IF(A1=B1,A1+(A1<C1)*10-C1,IF(ABS(A1-B1)=5,MIN(A1+(A1<C1)*10-C1,B1+(B1<C1)*10-C1)*10+MAX(A1+(A1<C1)*10-C1,B1+(B1<C1)*10-C1),"x"))

不可说7625

天有多高999 发表于 2024-3-11 23:33
=IF(OR(ABS(IMSUB(A1,B1))={0,5}),(MIN((A1B1)*((B1

0缺了