Formula help for a newbie

[scoop1973]

Hi,
could anyone please tell me the formula for the following scenario, just bought tourney director today and have a tourney tomorrow night that I would like to use it for.

Say we have 20 entrants (this varies from week to week), the first player to bust out will receive 100 points, 2nd out 200, 3rd 300 etc.

The top 3 places are awarded additional points, 1st 1000, 2nd 600, 3rd 300.

The player finishing 1st will recieve a total of 3000 points, 2000 for winning and 1000 bonus.

Thanks in advance

[Corey Cooper]

(n-r+1) * 100 + switch(r, 1, 1000, 2, 600, 3, 300)

Note that this formula changes with the number of entrants.  First place in a tournament of 20 people will receive 3000 points (2000 + the bonus 1000), but first place in a tournament of 50 people will receive 6000 points (5000 + the bonus 1000).

[scoop1973]

Many thanks