in our tournaments we would like to setup and apply so that the final 9 players recieve point as below
1st = 100
2nd =90
3rd =80
4th =70
5th =60
6th =50
7th =40
8th =30
9th =20
switch(r,1,100,2,90,3,80,4,70,5,60,6,50,7,40,8,30,9,20)
and also so that it gives the final 9 the amount of points of people in the tournament
lets say there was 35 players in the tournament
first place would get 100+35 for a total of 135 ect
The variable
n represents the number of people in. So, just add that to the end (or beginning). But, we only want it for the top 9. and get switch(r,1,100,2,90,3,80,4,70,5,60,6,50,7,40,8,30,9,20)+if(r=<9,n,0) <-- r stands for rank.
I'm sure there's an easier way to do the 1st to 9th place points, too, so don't be surprised if someone else posts an answer
but this should get you started, at the very least.