I understood that from your original post. The basic problem is that (even
when rounding to the same degree everywhere) the rounded sum of numbers need
not be equal to the rounded sum of rounded numbers.

What you are trying to do distorts the data. If the consumers of your
report need to see the components, then wouldn't it be better to simply
explain that mathematical reality to them rather than giving them distorted
data?

Taking your actual example, note that the sum of all the raw numbers is
216,740, which rounds to 216,700, not 216,800 (the first distortion).
Second, if the consumers need to see the hundreds in sub1-sub3, how does it
help them to see a wrong hundreds figure in at least one of them? Moreover,
if they can tolerate a distortion in those figures why distort the smallest
value (14% distortion) instead of the largest value (0.2% distortion)?

Jerry

"Saintsman" wrote:

Hope this explains better! The document is primarily for presentation & I
want to round totals.
I add numbers below subtotal I'm afraid so subtotal 1 = 30150+75400 etc
Only subtotals and grand totals will be visible on the final document, but
they do need to add up correctly

subtotal 1 105,600 round=100
30,150
75,400
subtotal 2 109,800 round=100
7,000
73,500
19,550
9,720
subtotal 3 1,400 round=100
1,420

Grand total 217,000 round=1000
216,800 actual (sub1+sub2+sub3)
200 balancing total added to subtotal 3

How can I add the balancing figure to a subtotal (apart from doing it
manually)