View Full Version : Arithmetic Errors

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

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.


In pure math terms, the order of operation can differ from Excel's order. When in doubt, force order with ()'s.