I think you'll have to provide some more information; given your sample
numbers, one of your .40 items will have to be rounded down, the other
rounded up in order to meet your criteria. Are these in order of importance,
where the higher percentage item (26%) would be the ideal item to round up in
a tie, and the lower item (6%) would be the one to round down? What if your
results were to have each of the first 5 numbers end in .2, what logic would
you use to decide who gets the extra, and who loses out?

If this is a money pot, why round it at all- why not just pay the amounts
listed (other than convenience)?

What rules are you bound by- can you just round everyone down and put the
remainder in the next pot?

Alternatively, instead of rounding the dollar values directly, can you round
the source percentages to the nearest 5?? That would give you (at least in
this instance) whole number payouts that sum to 2040. The individual payouts
would vary from your original number anywhere from 0 to ~41 dollars, but
again, I don't know if your rules permit this type of adjustment.

HTH,
Keith

"renwaters" wrote:

Hello
I want to round money that is in a pot to pay out 6 places.
877.20
530.40
244.80
163.20
122.40
102.00
sum = 2040.00

I want to round but the sum can't be less than 2040 or more than 2040.

Please help