Thank you Mr. Toad, i think we have a conlusion: there is no special function that will do the "+ .50" trick.
And if there is, nobody knows it.
But now you raise a different issue, that was not part of the original question.
I have never said that after distribution i would accept a difference from the original amounts! I only said I like integers.
It is fair to say that there are very few accountants reading this post. :-)
Because this is about the age old problem of "how to distribute x amounts over y recepients, in a fair manner".
Sloppy systems divide by y-recepients, round, and stuff the residue into the last recepient's amount, or post it under "calculating differences".
Surely, clever guys can think out of the box and find an easy way to balance everything. With 1_000_000 samples or with just one. :-)
to be distributed amongst 5, 17, 99 or... any number of recepients.
Paul
And if there is, nobody knows it.
But now you raise a different issue, that was not part of the original question.
I have never said that after distribution i would accept a difference from the original amounts! I only said I like integers.
It is fair to say that there are very few accountants reading this post. :-)
Because this is about the age old problem of "how to distribute x amounts over y recepients, in a fair manner".
Sloppy systems divide by y-recepients, round, and stuff the residue into the last recepient's amount, or post it under "calculating differences".
Surely, clever guys can think out of the box and find an easy way to balance everything. With 1_000_000 samples or with just one. :-)
to be distributed amongst 5, 17, 99 or... any number of recepients.
Paul