It seems as though Excel 2010 is subtracting 0.00000000000001 from a currency value. I have found this in several tabs of my spread sheet. It looks something like this:
(blank cell) (blank cell) $135.57 135.57
-$42.38 (blank cell) $93.19 $93.19
(blank cell) $1000.00 1093.19 1093.19
In column E I have the equation =IF(C3=D3,"P","False") which shows a P for the first row, False in the second row and P in the third row. The second row should have P displayed.
Looking at the length of the values I see the length of the first $93.19 is 16 characters! expanding it out I get 93.1899999999997
How does this happen at different points of the excel spreadsheet/workbook and how can I correct this?