formula problem !!!!

[sscrazy]

OK, I want my point system to go
1st  100
2nd  90
3rd  80

10th 10
11th  00

I came up with 10*(11-r)   but this formula is giving me negative points for people that don't make the top ten.  I need it where it just gives 0 points for 11th place and under.  Thanks for your help.

[Phaze]

if(r < 11, 10*(11-r), 0)

This is exactly what you wanted however take a look at this one and see which you like better:

if(r < 11, (n - r) * 10, 0)

[sscrazy]

Thanks a million Phaze.  I am algebra retarted.   

[Phaze]

heh heh, no problem, I am too

The difference between the two formulas is that the first one will give 0 - 100 points to the final 10 people... the second formula gives the top 10 finishers points based on how many people played in that tournament. The more people that played in the tournament the more points the top 10 will get... it kinda awards the top 10 people for going through or out lasting more people