Hi,
for the league we are playing, I'm looking for a formula. Half of the number of players will finish in the points, the last one of these players in the points will get
10 points. The rest of the players we would like to give 10% more points then the previous one, so if we have 60 players, 30 of them will get points. 30th will
get 10 points, 29th -> 11 points, 28th -> 12 points, 27th -> 13 points, 26th -> 14 points, 25th -> 15 points, 24th -> 17 points, and so on.
The points needs to be rounded down when the points are ,5 or lower and up if they are ,6 or higher. I hope it makes a bit of sense wath I'm asking.
Can anyone give me the formula to do this?
Best regards,
Dave