Excel Tip: Dealing With Rounding Errors
For example, consider this calculation:
If you display your Excel spreadsheet without decimal places, the calculation is rewritten like this:
The answer is technically correct, but who's going to believe it?
One way in which you can solve this problem is to request that Excel present the worksheet in "Precision as displayed" mode, which means that all numbers will be rounded to the actual number that is displayed. Apply this option by selecting the Tools menu, then choosing Options, Calculation, and checking the "Precision as displayed" box. Click OK to execute this change.
The result will be a calculation that appears thus:
Note that this change will be made with respect to this worksheet only.