The following occurs in Excel 2007 and 2010:
In cell A1 enter: .011
In cell A2 enter: -.01
In cell A3 click AutoSum
The correct answer is: .001
Select all 3 cells, right-click and select Format Cells..., select Number, and change Decimal places to 30. :confused:
This error...