View Full Version : Arithmetic Errors
magelan
11-05-2013, 09:18 AM
I remember back when I was doing Java programming that there was a specific set of circumstances you could force to make Java totally fail at simple arithmetic operations [like 2 + 2 = 93].
Are there any arithmetic errors you can force like this in VBA?
Kenneth Hobs
11-05-2013, 10:07 AM
1/0
You can search for "Excel Math Errors" and find many examples. Most have to do with the computers floating point numerical precision. It is a computer issue, not an Excel issue. Many errors like this look fine now in 2010 but are still there. e.g.
907122.87-901253.44<>5869.43
In pure math terms, the order of operation can differ from Excel's order. When in doubt, force order with ()'s.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.