Originally Posted by
JBeaucaire
Welcome to the world of Excel and precision math. This one gets a lot of people.
Simple answer, always employ a ROUND() function with your disivion functions to avoid these penny errors that crop up. This is because what is displaying to you is not the exact value IN the cell. The exact value goes out many decimal places and those extra decimal places can add up hidden and create pennies you don't expect.
So, in H2 you have:
=IF(C2="","",(C2*D2)/100)
The portion in red is the division function, slip it into a ROUND() function to make the value exactly 2 decimals:
=IF(C2="","",ROUND((C2*D2)/100,2))
By fixing the rounding in your source cells, the SUM() functions will be what you visually expect.
Bookmarks