Consulting

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
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,911
    Location
    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.
    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
  •