[算表] excel使用公式判定該欄值不變？
軟體： excel 2016
如題，目前想到中間就卡住
if( mod(row(),2)=0, “Good”, 不變動該欄值)
我只想改變列為二的倍數的值，
奇數列的值不需變動，
請問後面
不變動該欄值 的部分有辦法寫嗎？
謝謝
-----
Sent from JPTT on my LGE LG-H962.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 180.204.68.119
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1497009134.A.E2A.html
※ 編輯: hitsuchi (180.204.68.119), 06/09/2017 19:53:13
→
06/09 20:04, , 1F
06/09 20:04, 1F
→
06/10 00:49, , 2F
06/10 00:49, 2F
→
06/10 00:49, , 3F
06/10 00:49, 3F
→
06/10 00:50, , 4F
06/10 00:50, 4F
→
06/10 00:56, , 5F
06/10 00:56, 5F
→
06/10 00:56, , 6F
06/10 00:56, 6F
→
06/10 01:01, , 7F
06/10 01:01, 7F
→
06/10 07:32, , 8F
06/10 07:32, 8F
→
06/10 07:32, , 9F
06/10 07:32, 9F
→
06/10 07:32, , 10F
06/10 07:32, 10F
→
06/10 07:35, , 11F
06/10 07:35, 11F
→
06/10 07:35, , 12F
06/10 07:35, 12F
→
06/10 07:37, , 13F
06/10 07:37, 13F
→
06/10 07:37, , 14F
06/10 07:37, 14F
→
06/10 08:54, , 15F
06/10 08:54, 15F
→
06/10 08:55, , 16F
06/10 08:55, 16F
→
06/10 08:55, , 17F
06/10 08:55, 17F
推
06/10 10:51, , 18F
06/10 10:51, 18F
推
06/10 10:54, , 19F
06/10 10:54, 19F
→
06/10 10:54, , 20F
06/10 10:54, 20F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
