I am trying to setup a league, and need the points to be as follows
For every person playing, there will be 200 points in the pot.
These will be distrubuted as follows
1. 30%
2. 20%
3. 13%
4 10%
5. 9%
6. 7%
7. 6%
8. 5%
Players positioned 9 onwards to recieve 80 points each.
Any help appreciated.. .Thanks in advance
I am thinking its something like this...
if(r = 1, (n * 200) *.30),
if(r = 2, (n * 200) *.20),
if(r = 3, (n * 200) *.13),
if(r = 4, (n * 200) *.10),
if(r = 5, (n * 200) *.09),
if(r = 6, (n * 200) *.07),
if(r = 7, (n * 200) *.06),
if(r = 8, (n * 200) *.05),
if(r > 8, (1 * 80))
But this only assigns 80 points to the places 9 onwards.
It seems to ignore the 1st 8 places :-s