Access 奇怪的無條件捨去 Int 函數
在 Access 的 VBA 中
vInt = 77.32 * 0.5 ==> 38.66
vInt = 77.32 * 0.5 * 100 ==> 3866
vInt = Int(77.32 * 0.5 * 100) ==> 3865 竟然少1
vInt = Int(77.32 * 0.5 * 100) / 100 ==> 38.65 取小數第二位無條件捨去的結果,竟然少0.01
vInt = 77.32 * 0.5 * 100 ==> 3866
vInt = Int(vInt) / 100 ==> 38.66 將數值成 100 放在變數,再將變數取整數,再除於100,則結果就沒問題
不知這是什麼問題, 看來只好多用一條式子,再轉換,而不能一式到底,這是不是 呷緊弄破碗
迴響
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Admiring the persistence you put into your website and in depth information you present.
It's great to come across a blog every once in a while that isn't the same out of date rehashed information. Great read!
I've saved your site and I'm including your RSS feeds to my Google account.
Access 奇怪的無條件捨去 Int 函數 | 豬窩
excellent points altogether, you just won a new reader.
What may you recommend about your put up that you simply
made a few days in the past? Any sure?
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Very rapidly this site will be famous amid all blogging and site-building visitors, due
to it's good articles
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Cbd oil that works 2020
Pretty! This was an incredibly wonderful post. Thanks for
providing this information. best rated cbd oil http://t.co/4kPhN7Ek0L cbd oil
that works 2020 http://t.co/4kPhN7Ek0L
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Thank you for every other wonderful post. Where else may anybody get that kind
of information in such a perfect method of writing?
I've a presentation subsequent week, and I am at the look
for such information.