本帖最后由 心正意诚身修 于 2015-6-20 22:52 编辑
D组长:心正意诚身修
第一题,解法一。- =LEFT(SUBSTITUTE(TEXT(ROW(A1234),TEXT(5555,REPT("!00",LEN(A2)))),5,"、"),7)
复制代码 解法二- =SUBSTITUTE(SUMPRODUCT(COLUMN(A:D)*10^(8-COLUMN(A:D)*2)),"0","、")
复制代码 解法三- =SUBSTITUTE(TEXT(ROW(A1234),"0-0-0-0"),"-","、")
复制代码 解法四- =TEXT(ROW(A1234),"0、0、0、0 ")
复制代码 解法五- =LEFT(TEXT(ROW(A1234),REPT("0、",4)),7)
复制代码 第二题:- =TEXT(COLUMN(INDIRECT(ADDRESS(1,1234,,,))),"0-0-0-0")
复制代码 第三题 方法一- =CHOOSE(COLUMN(A1),MOD(ROW(A2),2),ROW(B1)*10-9,MOD(ROW(A1),2))
复制代码 方法二- =IF(MOD(COLUMN(),2),ROW(A1)*10-9,ABS(INT(COLUMN(A1)/2)-MOD(ROW(A2),2)))
复制代码 方法三- =CHOOSE(MOD((ROW(A1)-1)*4+COLUMN(A1)*(-1^ROW(A2)),4),0,ROW(A1)*10-9,1)
复制代码 方法四,數組公式- =--(MOD(ROW(A1)-{1,1,0},{2,9,2})&{"",1,""})
复制代码 |