|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 mmlzh 于 2019-12-4 21:04 编辑
貌似与出题初衷不一致
158
=SUM(IF((ABS(5-ROW(1:9))=5-O2)+(ABS(5-COLUMN(A:I))=5-O2),,C3:K11))-(O2>5)*G7-(O2>6)*SUM(F6,H6,F8,H8)-(O2=8)*SUM((ABS(5-ROW(1:9))+ABS(5-COLUMN(A:I))=4)*C3:K11)
149
=SUM(C3:K11*(((ABS(5-ROW(1:9))=5-O2)+(ABS(5-COLUMN(A:I))=5-O2)=0)-(O2=8)*((ABS(5-ROW(1:9))+ABS(5-COLUMN(A:I))=4))))-(O2>5)*G7-(O2>6)*SUM(F6,H6,F8,H8)
非引用单个单元格163
=SUM(C3:K11*(((ABS(5-ROW(1:9))=5-O2)+(ABS(5-COLUMN(A:I))=5-O2)=0)-(O2>5)*MOD(ROW(1:9)+COLUMN(B:J),2)*(4^(O2-6)>TEXT((5-ROW(1:9))^2+(5-COLUMN(A:I))^2,"[=4]19")-1)))
149
=SUM(C3:K11*(((ABS(5-ROW(1:9))=5-O2)+(ABS(5-COLUMN(A:I))=5-O2)=0)-(O2>5)*MOD(TEXT((5-ROW(1:9))^2+(5-COLUMN(A:I))^2,"[=4]1;[>"&4^(O2-6)&"]1;0")+1,2)))
|
评分
-
18
查看全部评分
-
|