Solved

# Round using Excel

Posted on 2011-02-15

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?