>That's what I said in my previous message, but thought I was wrong, but you've proved it now.
>
>So my only option is to ROUND(ROUND(7/74*100,1),0).
OK, so that gives you "10", which solves your problem of percentages not adding up to 100 with this set of numbers (if I understand your problem correctly). If this is a one-time problem, then you are done.
But the next time you run this with different numbers, there is no guarantee that you will add up to 100 -- in fact you probably will not.
For example, what if you had these three numbers:
7/74 = 9.459 = 9.5 = 10
64/74 = 86.486 = 86.5 = 87
3/74 = 4.054 = 4.1 = 4
-----
101
