Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Taz71

Pages: [1]
Help Me / Need Help with Formula
« on: May 11, 2011, 01:32:30 AM »
Our league has 10 tournaments and we drop everyone's lowest 2 scores providing they make all 10 tournaments.  However, if someone only makes 9 tournaments, we would drop their lowest 1 score.  If someone makes 8 tournaments or less, we don't drop any scores.  I think the way to add this to the overall scoring formula is using the # of buy-ins for the player but I don't know how to implement this into the formula.

I tried using the following formula but it doesn't work.  Any help with this is greatly appreciated.

assign("c", count(scores))
if(buy-Ins = 10, sum(top(c-2, scores))), if(buy-Ins = 9, sum(top(c-1, scores))), sum(scores)

Pages: [1]