【字符争霸】第13期：金额取整

满坛皆为吾师

第一发　119

1. =INT(A3)+IF((-LEFT(RIGHT(A3/1%,2),1)<>0)*(-1^(LEFT(RIGHT(A3/1%,2),1)+(-RIGHT(A3/1%,1)<>0)*(-1^RIGHT(A3/1%,1)=1))=1),1,)

复制代码

第二发　89

1. =INT(A3)+(COUNT(FIND({2,4,6,8},LEFT(RIGHT(A3/1%,2),1)),FIND({2,4,6,8},RIGHT(A3/1%,1)))=1)

复制代码

第三发　63

1. =INT(A3)+(SUM(-1^TEXT(MID(RIGHT(0&A3/1%,2),{1,2},1),"0;;1"))=0)

复制代码

珺珺妈

公式好长啊。

1. =IF(ISODD(RIGHT(IF(ISODD(RIGHT(A3/1%)),FLOOR(A3,0.1),CEILING(A3,0.1))*10)),FLOOR(IF(ISODD(RIGHT(A3/1%)),FLOOR(A3,0.1),CEILING(A3,0.1)),1),CEILING(IF(ISODD(RIGHT(A3/1%)),FLOOR(A3,0.1),CEILING(A3,0.1)),1))

复制代码

baksy

=(-2^(RIGHT(INT(A3*10))+(-2^RIGHT(A3/1%)>1))>1)+INT(A3)

天龙九部

1. =INT(A3)+ISNUMBER(MATCH((ISNUMBER(MATCH(RIGHT(TEXT(A3,"0.00"))*1,{2;4;6;8},))+MID(TEXT(A3,"0.00"),FIND(".",TEXT(A3,"0.00"))+1,1)),{2;4;6;8},))

复制代码

xuyouxm

用笨办法做一个，感觉好长！

1. =IF(--LEFT(MID(A3,FIND(".",A3&".")+1,2)&0,1)=0,INT(A3),IF(MOD(IF(AND(LEN(MID(A3,FIND(".",A3&".")+1,2))=2,MOD(RIGHT(A3,1),2)=0),LEFT(MID(A3,FIND(".",A3&".")+1,2),1)+1,LEFT(MID(A3,FIND(".",A3&".")+1,2),1)),2)=0,INT(A3)+1,INT(A3)))

复制代码

滴答滴

1. =INT(A3)+OR(MOD(A3*50,50)=ROW($6:49)-MOD(INT(ROW($10:53)/5),2)/2)

复制代码

1. =INT(MOD(INT(FIXED(A3&1)*110),2)*0.9+A3)

复制代码

1. =INT(A3+0.9*(MOD(-A3*110,2)<1))

复制代码

砂海

占楼.
=INT(A3)+((MID("0010101010",1+RIGHT(FIXED(A3)),1)+MID("0010101010",1+MID(FIXED(A3-INT(A3)),3,1),1))=1)

=INT(A3)+(SUM(--MID("0010101010",1+MID(FIXED(A3-INT(A3)),{3,4},1),1))=1)

路边的记忆

先交个卷

1. =INT(A3)+MOD(INT((A3&1)/1%)-INT(SUBSTITUTE(1&A3,0,)*10),2)

复制代码

lmze2000

1. =INT(A3)+IF(-RIGHT(INT(A3/0.1))=0,0,IF(LEN(A3)-FIND(".",A3&".")=1,1-MOD(RIGHT(INT(A3/0.1)),2),MOD(RIGHT(INT(A3/1%))+RIGHT(INT(A3/0.1)),2)))

复制代码

用笨方法来做吧。
就是处理角位的0比较讨厌啊。

换了个思路，又短了一些。

1. =INT(A3)+SUM((RIGHT(INT(A3/0.1))+SUM((--RIGHT(A3/1%)={2,4,6,8})*1)={2,4,6,8,10})*1)

复制代码

sinowonder

=INT(A3)+MOD(SUM(MOD(SUBSTITUTE(RIGHT(INT(A3*10^{1,2})),0,1),2)),2)