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 ...
Could the actual numbers have more decimals than are being displayed?
For example, if A1 contains 0.407 and B1 contains 0.326, you'll see 0.41 and 0.33 when you display them as number with 2 decimal places.
The sum is 0.407+0.326 = 0.733. This will be displayed as 0.73.
You can check this by temporarily changing the number format of the source cells and of the sum to General.