Forum Discussion
Round up Problem in excel
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.