Round using Excel
Posted on 2011-02-15
I've got 4 numbers in MS Excel.
When I sum them, I get 1
To get them to %, I multiply them by 100 and Round them by 2 to display for the user using something like =ROUND(D4*100,2)
When I sum that I get 100.01
I'm just using excel to demonstrate my problem. I'm using the same method in one of my applications to display the % in ingredients, but the total is 100.01% and must be 100%.
What can I do to get the correct total?