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)
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)