[第128期]变形计(已结)

太阳之子

1. =SUM(IF(IF(O2<6,(ABS(5-ROW(1:9))+O2=5)+(ABS(5-COLUMN(A:I))+O2=5),(ROW(1:9)*COLUMN(A:I)=25)+IF(O2>6,ABS(5-ROW(1:9))*ABS(5-COLUMN(A:I))=1)+IF(O2=8,ABS(5-ROW(1:9))+ABS(5-COLUMN(A:I))=4)),,C3:K11))

复制代码

T100

168字符估计是没戏了；228字符的思路来一个，不知是否合规；数组公式。
=SUM(((ABS(ROW(1:9)-5)<>5-O2)*(ABS(COLUMN(A:I)-5)<>5-O2)-(ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)<=2*O2-12)*ISEVEN(ROW(1:9)+COLUMN(A:I)))*C3:K11)+SUM(N(OFFSET(G1,4*ROW(1:2),))+N(OFFSET(A7,,4*ROW(1:2))))*(O2>6)

补充内容 (2019-12-11 17:11):
=SUM(((ABS(ROW(1:9)-5)<>5-O2)*(ABS(COLUMN(A:I)-5)<>5-O2)-(ABS(ROW(1:9)-5)*ABS(COLUMN(A:I)-5)=1)*(O2>6)-(ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)=4)*(O2=8))*C3:K11)-INDEX(A:I,7,7)*(O2>5)

solextrade

烧脑的数学题，终于写出来了，很欣慰156字

=SUM(C3:K11*(5-ABS(ROW(1:9)-5)<>IF(O2=8,ABS(5-COLUMN(A:I))+1,O2))*(5-ABS(COLUMN(A:I)-5)<>O2)*(IF(ABS(ROW(1:9)-5)<O2-5,ABS(ROW(1:9)-5))<>ABS(5-COLUMN(A:I))))

265094

=SUM(C3:K11*(((5-ABS(ROW(1:9)-5)=O2)+(5-ABS(COLUMN(A:I)-5)=O2)=0)-ISODD(TEXT((1+ABS(5-ROW(1:9)))^2+(1+ABS(5-COLUMN(A:I)))^2,"[=10]1;[>"&3^(O2-5)&"]1;0")+1)))

aoe1981

头都快想破了，就只做了一个长度为179，差距大啊……

1. =SUM(C3:K11*IF(O2<6,--ISERR(SEARCH(5-O2,(ROW(1:9)-5)&(COLUMN(A:I)-5))),1-(((ROW(1:9)-5)^2=(COLUMN(A:I)-5)^2)*((ROW(1:9)-5)^2<O2-5)+(O2=8)*(ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)=4))))

复制代码

这个还应当再优化一下。

象山海鲜

1. =SUM(ISERR(0/IF(O2<6,FIND(5-O2,ROW(1:9)-5&COLUMN(C:K)-7),DAY(4&1/(4-(ROW(1:9)-5)^2-(COLUMN(C:K)-7)^2)^-1/2-24)<(O2-6)^9+23))*C3:K11)

复制代码

sucx007

1. =SUM(IF((ABS(ROW(1:9)-5)=5-O2)+(ABS(COLUMN(A:I)-5)=5-O2)+((ROW(1:9)-5)^2=(COLUMN(A:I)-5)^2)*(ABS(ROW(1:9)-5)<O2-5)+(O2=8)*(4-ABS(ROW(1:9)-5)=ABS(COLUMN(A:I)-5)),,C3:K11))

复制代码

anonym

1. =SUM(IF((ABS(ROW(1:9)-5)=5-O2)+(ABS(COLUMN(A:I)-5)=5-O2)+MMULT(N(ABS(ROW(1:9)-5)=O2-{6,7,8}),N(ABS(COLUMN(A:I)-5)=O2-{6;7;8}))+(ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)=4*O2-28),,C3:K11))

复制代码

猫头鹰的喵

=CHOOSE(INT(O2/6)+1,SUM((IFERROR(0/FIND(ABS(O2-5)&"",TEXT(ABS(ROW(1:9)-5)+ABS(COLUMN(A1:I1)-5)/10,"0.0")),1))*C3:K11),SUM((ISODD(IF(ABS(5-ROW(A1:A9))^2+ABS(COLUMN(A:I)-5)^2>4^MOD(O2,6),1,ABS(5-ROW(A1:A9))^2+ABS(COLUMN(A:I)-5)^2))+(ABS(5-ROW(A1:A9))^2+ABS(COLUMN(A:I)-5)^2=IF(4^MOD(O2,6)>1,4,3)))*C3:K11))
超过300个字符,想了一天实在不知道有什么矩阵能够那么符合。对于我个人来说能够做出来已经是满足了。期待各位老师的答案多向各位学习

LSL1128xgw

=SUM(((ABS(ROW(1:9)-5)-5+O2)*(ABS(COLUMN(A:I)-5)-5+O2)*((O2<7)+(ABS(COLUMN(A:I)-5)+ABS(ROW(1:9)-5)-O2/2)*((5-ROW(1:9))^8-(COLUMN(A:I)-5)^2))<>N(O2=6))*C3:K11)