Results 1 to 2 of 2

Thread: Arithmetic Errors

  1. #1

    Arithmetic Errors

    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?

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Nov 2005
    Tecumseh, OK

    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.
    Last edited by Kenneth Hobs; 11-05-2013 at 10:24 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts