BUG: Floating Point Operations Errors with low precision numbers
Excel is incorrectly performing math operations.
Cell B2 = 6.2
Cell C2 = 5.85
Cell D2 = C2-B2
Answer = -0.3500000000000010
This is incorrect. The answer is 0.35, with no rounding required. This is causing several operations in my worksheet to fail. I shouldn't need to work around this using TRUNC().