Please Help With Point Formula..

[ShaneR]

Hello TD Users! I was hoping I could get some help implementing a point formula..

I would like to use the following system, but can't seem to figure out how to properly write the formula:

1 Point for Playing, then the following points for the final table:
1st - # of Players x 5 (+1 for Playing)
2nd - # of Players x 4 (+1 for Playing)
3rd - # of Players x 3 (+1 for Playing)
4th - # of Players x 2 (+1 for Playing)
5th - # of Players (+1 for Playing)
6th - # of Players / 2 (+1 for Playing)
7th - # of Players / 4 (+1 for Playing)
8th - 1 Point (+1 for Playing)


If anybody knows how I would write this into the formula box to get it working correctly, I would be ever so appreciative!

Thanks in advance,
Shane

[Corey Cooper]

n * switch(r, 1, 5, 2, 4, 3, 3, 4, 2, 5, 1, 6, .5, 7, .25, 8, 1/n, 0) + 1