I've got 4 numbers in MS Excel.
0.010989011
0.21978022
0.32967033
0.43956044
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)
1.1
21.98
32.97
43.96
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?
When i sum the first numbers: I get 1.000000001
When I sum the Second numbers I Get = 100.01
But that's not the point.
And Easy way is to do is
=ROUND(D4*100,0) ==> this way all Digits are removed ==> 1.000000001
becomes 100
=ROUND(D4,0) ==> this way all Digits are removed ==> 100.01 becomes 100