When I was in first grade, I learned that 2 + 2 = 4. Excel, who I have come to know and trust, thinks the answer is five. How is this possible?
The truth is told after I increase the decimal places shown for each of these cells. The twos on the spreadsheet really aren’t twos after all. They’re 2.43 and 2.35, which both round down to two. The sum, 4.78, rounds up to five.
To fix this kind of rounding difference in …
Social Media