Formula help - Easy one I think

[skelly82]

Hi guys we have started a new structure layout for tonight but I just can't seem to get it to work.

I would like for every player 5 points for playing, then for the top final 9 players 5 points for making the table. Then have the following points;

9th = 2
8th = 4
7th = 6
6th = 8
5th = 10
4th = 12
3rd = 14
2nd = 25
1st = 50

I hope that covers everything - any help would be greatly appreciated. 

Skelly 

[badbeat]

Try this, I think it should work and I've done it as you laid it out so you can easily change it in the future.

5+if(r<10,5,0)+switch(r,1,50,2,25,3,14,4,13,5,10,6,8,7,6,8,4,9,2)

[skelly82]

Worked like a charm - many thanks

Skelly