Main > General Discussion

Getting a formula correct

(1/1)

**jrwilson1946**:

I have been attempting to set up a formula with the following criteria.

The top 16 positions receive points regardless as the number of players. 1st place gets 16 points, 16th place gets 1 point, 17th through 48th place receive 0 points. I have not been able to work out the formula.

Thanks for your help in advance.

**TimDugan**:

You're going to have to set up this in prize form under the "prizes" tab. There's no way to program a formula the way you want to (as of yet).

**MooseWizard**:

Try the following:

max(17-(r), 0)

This should provide the higher of the two variables, either 17 minus rank, or 0.

For 1st place, 17-1= 16 points

for 2nd place, 17-2= 15 points

for 3rd place, 17-3= 14 points

...

...

for 16th place, 17-16= 1 point

for 17th place, 17-17= 0 points

for 18th place, 17-18= -1, in which the equation will award 0 points instead because 0 is greater than -1.

...

...

for 48th place, 17-48= -31, in which the equation will award 0 points instead because 0 is greater than -31.

This should work for what you need.

**TimDugan**:

Ooo, does that actually work? Sweet.

Navigation

[0] Message Index

Go to full version