Why does Excel not round according to 8-byte IEEE 754
The article that you linked to is explicit about doing something nonstandard with values near 0: Example when a value reaches zero 1.In Excel 95 or earlier, enter the following into a new workbook: A1: =1.333+1.225-1.333-1.225 2.Right-click cell A1, and then click Format Cells. On the Number tab, click Scientific under Category. Set the Decimal … Read more