[算表] 數字檢驗
軟體：excel 2007
因為工作每個月需要收集幾百支指標並對外提報，因為是用excel收集數據且每月提報，想先以檢驗本月數字是否與上個月差異大於20%來避免人工輸入錯誤情形，不曉得excel是否有函數可做此檢驗！謝謝大家
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.8.181.1
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1402961052.A.ECA.html
→
06/17 09:02, , 1F
06/17 09:02, 1F
→
06/18 06:10, , 2F
06/18 06:10, 2F
→
06/18 06:11, , 3F
06/18 06:11, 3F
→
06/18 09:48, , 4F
06/18 09:48, 4F
→
06/18 15:19, , 5F
06/18 15:19, 5F
→
06/18 15:19, , 6F
06/18 15:19, 6F
→
06/18 15:22, , 7F
06/18 15:22, 7F
→
06/18 15:22, , 8F
06/18 15:22, 8F
→
06/18 16:53, , 9F
06/18 16:53, 9F
→
06/18 16:59, , 10F
06/18 16:59, 10F
→
06/18 17:00, , 11F
06/18 17:00, 11F
→
06/18 17:06, , 12F
06/18 17:06, 12F
→
06/18 17:06, , 13F
06/18 17:06, 13F
→
06/20 08:31, , 14F
06/20 08:31, 14F
→
06/20 08:41, , 15F
06/20 08:41, 15F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
