Forum Discussion
Round up Problem in excel
In your specific example of counting rubies the rounding error is +1 (71 compared to 70). You should deduct 1 ruby from the player with the highest points, as this will result in the lowest relative adjustment (=fairest). It will also work when your initial rounding would result in 69 rubies.
I've added some formulae to demonstrate this in the attached workbook, hoping that you find it useful.
Note that this solution may not give the correct result in the rare occasion the rounding error is not equal to -1, zero or +1.
Thanks for your Answer and your work. It makes sense in my eyes for this game campaign.
I understand your way, but that's more the philosophical way, with an extra technical Part. What I don't understand is, that MS Excel isn't able to get a correct number of rubies for each Player, because my formulas was right.
I cannot accept, to make for every campaign an extra Field with corrections, just to get this philosophical right. Because may be next round, another player is great, so I have to change the field for this player.
Not sure I follow. Excel is no more than a calculator with a lot of extras. Your formulae may be correct, but your problem relates to rounding the calculated values for each person.
Suppose you want to divide 10 by 3 players, Excel could, as an example, tell you they get 1.333, 3.333 and 5.333 each. But, since your case only accepts whole numbers this becomes 1+3+5=9. There is no way that Excel can automatically determine which of the three shall get the one extra point. My logic says that the one for whom the relative error is least gets the extra one. Nothing philosophical about it.
