六角形 繪圖 (13707)

C3:U15{=TEXT(OR(COLUMN(A1)-ROW(A1)=IF({1,0},9,-4+(ROW(A1)>4)))+OR(COLUMN(A1)+ROW(A1)={23,11})+OR(ROW(A1)={4,10}),"X;;")

另解=IF(OR(ROW(A1)-COLUMN(A1)={-9,3},COLUMN(A1)+ROW(A1)={11,23},ROW(A1)={4,10}),"X","")



留言

  1. =IF(OR(ROW(A1)-COLUMN(A1)={-9,3},COLUMN(A1)+ROW(A1)={11,23},ROW(A1)={4,10}),"X","")

    by piny

    回覆刪除
  2. =IF(OR(ROW(A1)-COLUMN(A1)={-9,3},COLUMN(A1)+ROW(A1)={11,23},ROW(A1)={4,10}),"X","")

    回覆刪除

張貼留言