Actually Excel is adding correctly.
You are adding the numbers Excel is displaying, which happen to result from two cells that Excel is rounding up for display purposes, and comparing that to what Excel is getting, by using the real numbers and happens to round down for display purposes.
If you take your column "I" and adjust the formatting to show 6 decimal places, you will see what Excel is really working with and what the real results are.
|