Golf League Spread Sheet Adjustment

[smarch]

Hello all,

I was on this forum a while ago and someone helped me create a spread sheet to track my golf league. It worked perfectly but now we have adjusted the "rules" of scoring and I need help.

The current rule int he spreadsheet is each player has a given quota (B2). The points are totaled for week one and entered into C2. For ever 2 points higher, the quota goes up 1 and for every 3 points lower, the quota goes down 1. That new quota is calculated in cell D2. Below is the formula which is being used:

=IF(C2="","",IF((C2-B2)=0,B2,IF((C2-B2)>0,B2+IF((C2-B2)>0,CHOOSE(C2-B2,0,1,1,2,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,10,10,11,11,12,12),B2),B2+CHOOSE((C2-B2)*-1,0,0,-1,-1,-1,-2,-2,-2,-3,-3,-3,-4,-4,-4,-5,-5,-5,-6,-6,-6,-7,-7,-7,-8,-8))))

We are adjusting the scoring system as follows: If the player goes up 2 or more from their starting quota (B2) in week 1 (C2), then the new quota goes up 1 (D2). If the player goes down 3 or more, then the new quota goes down 1.

I hope that's clear. Any help you can provide would be greatly appreciated.

Thanks!