formula help

[pieman]

could someone help with this it is all new to me and i am at a loss to work out the formula for our league

we are running a 10-15 man league over the next 40 weeks and the point system we use is
1st 10 points, 2nd 7 points, 3rd 5 points, 4th 3 points 5th 2 points and everyone else gets 1 points for attending

how would you work this out

your help would be appreciated guys

[Corey Cooper]

1 + switch(r, 1, 10, 2, 7, 3, 5, 4, 3, 5, 2)

[badbeat]

Should be

1 + switch(r, 1, 9, 2, 6, 3, 4, 4, 2, 5, 1)

[Corey Cooper]

Oops, you're absolutely right.  Or:

switch(r, 1, 10, 2, 7, 3, 5, 4, 3, 5, 2, 1)

[pieman]

thanks guys you are all stars

[jhisey]

So first place when 8 people show up gets the same points as first place when 15 show up?