正方形顯示 依輸入數字 (14946)

D2:R16=IF((ROW(A1)>$B$2)+(COLUMN(A1)>$B$2),"",IF((COLUMN(A1)=1)+(COLUMN(A1)=$B$2)+(ROW(A1)=1)+(ROW(A1)=$B$2),COLUMN(A1),""))



留言