I’m having a problem with excel calculating a simple formula and giving me the wrong answer. I’m expecting a zero, but instead excel returns a very small number.
To duplicate this, open excel and try this:
In a new workbook:
type 818,562.54 in cell A1
type -40,026.44 (negative) in cell A2
type 778,536.1 in cell A3
type the formula =A1-A3+A2 in cell A4
Show the answer to 16 decimal places
It should equal 0.00 but instead shows as: 0.0000000000582077
Intel Pentium processor math flaw or MS Excel calculation error?
Using the formula =A1+A2-A3 instead of the above formula gives
the correct answer of 0.00
Why the discrepancy?