菱形 平行四邊形圖案 (14939)

D2=IF(ROW(A1)>B$2,"",REPT(B$6,ROW(A1)*2+MOD(ROW(A1),INT(B$2/2)+1)*(ROW(A1)>INT(B$2/2)+1)*-4-1))

F2=IF(ROW(A1)>B$2,"",RIGHT(REPT(" ",99)&REPT(B$6,B$2),B$2*2-ROW(A1)))






留言

  1. =IF(ROW(A1)>B$2,"",REPT(B$6,2*MIN(ROW(A1),B$2-ROW(A1)+1)-1))

    回覆刪除
  2. =IF(ROW(A1)>B$2,"",REPT(" ",B$2-ROW(A1))&REPT(B$6,B$2))

    回覆刪除

張貼留言