PDA

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.