[問題] excel如何用小數點的數列?
軟體:Microsoft Excel
版本:2013
請問各位大大如何用數值100每次扣0.2扣到零為止的數列呢?
要往下拉能每個欄位扣0.2扣到零為止
用手慢慢key太累了
100
99.8
99.6
99.4
99.2
99
98.8
98.6
...
...
舉例這樣，只要數列往下拉有辦法做到嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.8.87.134
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1442590210.A.11F.html
→
09/18 23:40, , 1F
09/18 23:40, 1F
→
09/18 23:51, , 2F
09/18 23:51, 2F
→
09/18 23:55, , 3F
09/18 23:55, 3F
→
09/18 23:58, , 4F
09/18 23:58, 4F
→
09/18 23:58, , 5F
09/18 23:58, 5F
→
09/19 00:07, , 6F
09/19 00:07, 6F
→
09/19 00:12, , 7F
09/19 00:12, 7F
→
09/19 00:14, , 8F
09/19 00:14, 8F
→
09/19 00:14, , 9F
09/19 00:14, 9F
→
09/19 00:15, , 10F
09/19 00:15, 10F
→
04/30 22:08, , 11F
04/30 22:08, 11F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
