A5:Z16=IFERROR(LEFT(RIGHT(REPT(0,26)&SUMPRODUCT($M$2:$Z$2*10^(14-COLUMN($A:$N)))*N(OFFSET($A$3,,26-ROW(R1))),28-ROW(A1)-COLUMN(A1)))*1,)
A18:Z18=RIGHT(INT(SUMPRODUCT(MMULT(COLUMN(A:L)^0,A5:$Z16)*10^(COLUMN(A1)-COLUMN(A:$Z)))))*1
A18:Z18 格式化=SUM($A18:A18)=0
留言
張貼留言