[問題] excel.除法問題
軟體:excel
版本:2007
小弟有個小問題關於excel除法判別的問題
1,2,3,4,5,6,7,8,9,10 小弟用=MOD(哪一格,倍數)=0
譬如=MOD(A1,2)=0 ,是2的倍數,判別是否
如果數字數目大一點..excel..就會漏判好幾個
有好心人可以告訴我怎麼回事嗎?謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.138.138.238
→
03/29 22:27, , 1F
03/29 22:27, 1F
→
03/29 22:54, , 2F
03/29 22:54, 2F
→
03/29 22:55, , 3F
03/29 22:55, 3F
→
03/29 23:28, , 4F
03/29 23:28, 4F
→
03/29 23:30, , 5F
03/29 23:30, 5F
→
03/29 23:31, , 6F
03/29 23:31, 6F
推
03/30 06:58, , 7F
03/30 06:58, 7F
→
03/30 09:12, , 8F
03/30 09:12, 8F
→
03/30 10:06, , 9F
03/30 10:06, 9F
→
03/30 10:06, , 10F
03/30 10:06, 10F
推
03/30 13:15, , 11F
03/30 13:15, 11F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
