Arithmetic Errors

[magelan]

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]

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.