Need someone who writes me a formula...Please.

[felix]

Hi...
I have just started using the tournament director. In our earlier tournaments i used excel and i had a formula, where each player got the following points: 10*(number of participants - players finishing rank)
Also the first 3 places got a bonus of:
1st: 3*number of participants
2nd: 2*number of participants
3rd: 1*number of participants

Can anybody of you guys write a formula for me that i can put into TD, that assigns the points as i mentioned in the above.

I would be really happy if you can help me with this.

[Corey Cooper]

10 * (n - r) + if(r < 4, (4-r) * n)

[felix]

thank you very much for the quick help!
I have been away for a while so I wasnt able to reply.
The last days i hosted the first tournament using the TD and your formula worked really great!
Everything i had to type in excel by hand was done automatically and directly exported to Homepokertour.com.
I am really happy with the program.
So again, thank you!!!