Forum Discussion
Sum and Add not returning correct cents
Hi. I'm trying to sum a set of cells. It's obvious that the sum should be $.74 and sum is returning $.73. I've tried to add the individual cells and it is still returning $.73. Any ideas about where ...
AngeLeaRose Could it be that the numbers you see are in fact rounded? For instance, if two cells contain 1.5 and 1.5 and you have formatted them to display with zero decimals, you will see 2 and 2, but the SUM will be 3.