Hi Formula Gurus,
I'm looking for a formula that counts 5 points per placing up to 5th. Zero for last place. At 4th place, there is a point difference of 10points from 5th place, and 5 points again from 4th to 1st.
SO....if there are 10 players in the tournament, last gets 0, 9th = 5, 8th = 10, 7th = 15, 6th = 20, 5th = 25, 4th = 35, 3rd = 40, 2nd = 45, 1st = 50.
The amount of players will vary from 6 - 20. The 10 point difference always will happen between 4th and 5th places.
Also, 5 points are given for buy in. 10 points are given for early buy in ( cut off 15 mins before game ), 5 points are given for hits.
Anyway to do this?
Thanks,
John