[开_150]斗牛游戏[已总结]

jokie0913

jokie0913 发表于 2015-7-8 17:01
=IF(SUM(IF(MOD(ROW($1:$25),6)=1,,IF(MOD(LOOKUP(MOD(ROW($1:$25)-1,5)+1,ROW($1:$5),(A16:E16

=IF(OR((MOD((A2:E2<10)*A2:E2+TRANSPOSE((A2:E2<10)*A2:E2)-SUM((A2:E2<10)*A2:E2),10)=0)*(COLUMN(A:E)<>ROW($1:$5))),IF(MOD(SUM((A2:E2<10)*A2:E2),10),MOD(SUM((A2:E2<10)*A2:E2),10)&"点","牛"),MAX(A2:E2)&"大")

一维生物进化为二维生物，缩短到200字符整

1. =IF(OR((MOD((A2:E2<10)*A2:E2+TRANSPOSE((A2:E2<10)*A2:E2)-SUM((A2:E2<10)*A2:E2),10)=0)*(COLUMN(A:E)<>ROW($1:$5))),TEXT(MOD(SUM((A2:E2<10)*A2:E2),10),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

再减减，172字符

满坛皆为吾师

144

1. =IF(AND(RIGHT(SUMIF(A2:E2,"<10")-A2:E2*(A2:E2<10)-TRANSPOSE(A2:E2*(A2:E2<10)))+MUNIT(5)),MAX(A2:E2)&"大",TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"))

复制代码

cleverzhzhf

1. =IF(ISNA(MATCH("?.?0",TEXT(MMULT(1+IF(A2:E2>10,10,A2:E2)%,INT(MOD(COLUMN(A:AE)/2^{0;1;2;3;4},2))),"[>4]0;[<3]0;.00"),)),MAX(A2:E2)&"大",TEXT(MOD(SUMIF(A2:E2,"<10"),10),"0点;;牛"))

复制代码

176字符，目前还没有好办法再缩短了。。。

1. =IF(ISNA(MATCH("3?00",MMULT(100+(A2:E2<10)*A2:E2,INT(MOD(COLUMN(A:AE)/2^{0;1;2;3;4},2)))&0,)),MAX(A2:E2)&"大",TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"))

复制代码

149字符。
太纠结了，以至于我都想用COLUMN(1:1)、IFNA、BASE这些非正常的细节了。。。

jsxjd

142Chars:

1. =IF(OR(MOD(MMULT(A2:E2*(A2:E2<10)*10+1,N(2*MOD(COLUMN(C:Y)/2^ROW($1:$5),1)<1)),100)=3),TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

141Chars:虽然实际应用通过，但存在“浮点风险”

1. =IF(OR(MOD(MMULT(A2:E2*(A2:E2<10)+9%,N(2*MOD(COLUMN(C:Y)/2^ROW($1:$5),1)<1)),10)=27%),TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

xgg2001

1. =IF(COUNT(FIND(0,SUMIF(A2:E2,"<10")/(ROW($1:$5)>COLUMN(A:E))-(A2:E2<10)*A2:E2-TRANSPOSE((A2:E2<10)*A2:E2))),TEXT(RIGHT(SUMIF(A2:E2,"<10")),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

龙城飞将III

1. =IFERROR(TEXT(RIGHT(LARGE(IFERROR(1/(MOD(SUM(IF(A1:E1>10,10,A1:E1))-1/(ROW($1:$5)>COLUMN(A:E))*(TRANSPOSE(IF(A1:E1>10,10,A1:E1))+IF(A1:E1>10,10,A1:E1)),10)=0)*(TRANSPOSE(IF(A1:E1>10,10,A1:E1))+IF(A1:E1>10,10,A1:E1)),""),1)),"0点;;牛"),MAX(A1:E1)&"大")

复制代码

唐伯狼

原来12楼的帖子 找不到编辑按钮了

1. =IF(MIN(MOD(SUM(IF(A2:E2>10,10,A2:E2))-IF(ROW($1:$5)<COLUMN(A:E),IF(A2:E2>10,10,A2:E2)+TRANSPOSE(IF(A2:E2>10,10,A2:E2)),0.1),10)),MAX(A2:E2)&"大",TEXT(MOD(SUM(IF(A2:E2>10,10,A2:E2)),10),"0点;;牛"))

复制代码

wlc5201130

1. =SUBSTITUTE(TEXT(MIN(IF(SUBSTITUTE(DEC2BIN(ROW($7:$30)),0,)="111",MMULT(MOD(ABS(SUM(IF(A2:E2>10,10,A2:E2))*{0,1}-MMULT(MOD(INT(ROW($7:$30)/2^(5-COLUMN(A:E))),2)*IF(A2:E2>10,10,A2:E2),ROW(1:5)^0)),10),{10;1}))),"[>9]大;[=0]牛;0点"),"大",MAX(A2:E2)&"大")

复制代码

唉,减不到200下

xiaoyaoyao13

1. =IF(COUNT(FIND(0,IF(COLUMN(A:E)>ROW($1:$5),SUM(IF(A2:E2>9,10,A2:E2))-IF(A2:E2>9,10,A2:E2)-TRANSPOSE(IF(A2:E2>9,10,A2:E2)),1))),TEXT(RIGHT(SUM(IF(A2:E2>9,10,A2:E2))),"0点;;牛"),MAX(A2:E2)&"大")

复制代码

{:soso_e134:}{:soso_e134:}献丑献丑了～

WJX-online

1. =RIGHT(TEXT(COUNT(0/MOD(TEXT(MOD(MMULT(100+IF(A2:E2>9,,A2:E2),N(MOD(COLUMN(C:X)/2^ROW($1:$5)*2,2)<1)),300),"[<99]"),10)),"[>9]"&MAX(A2:E2)&"大;[<10]"&TEXT(RIGHT(SUM(IF(A2:E2>9,,A2:E2))),"0点;;牛")),3)

复制代码

长度正好197字节！截止日期为最后的一天了，弄了一个累死我的公式。

1. =TEXT(COUNT(0/MOD(TEXT(MOD(MMULT(100+IF(A2:E2>9,,A2:E2),N(MOD(COLUMN(C:X)/2^ROW($1:$5)*2,2)<1)),300),"[<99]"),10))-10,";"&TEXT(RIGHT(SUM(IF(A2:E2>9,,A2:E2))),"0点;;牛")&";"&TEXT(MAX(A2:E2),"0大;1!0大"))

复制代码

长度198思路一样，只是不用外套RIGHT