[VBA ] 數值精度的問題
遇到了個很基本卻不會的問題
程式碼:
dim A as double
dim Err double
Err = A - Cells("A1")
執行時用監看式看
A: 1.06 double
cells: 1.06 Variant
Err: 1.xxE-14 double
想問一下為什麼執行時,Err有時為0,有時非0
要如何改才會都為0呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.68.138.212
推
07/03 22:53, , 1F
07/03 22:53, 1F
→
07/03 22:55, , 2F
07/03 22:55, 2F
→
07/03 23:00, , 3F
07/03 23:00, 3F
→
07/03 23:01, , 4F
07/03 23:01, 4F
→
07/03 23:01, , 5F
07/03 23:01, 5F
→
07/04 00:18, , 6F
07/04 00:18, 6F
→
07/04 00:19, , 7F
07/04 00:19, 7F
→
07/04 00:26, , 8F
07/04 00:26, 8F
→
07/04 00:26, , 9F
07/04 00:26, 9F
→
07/04 11:40, , 10F
07/04 11:40, 10F