I’m trying to come up with a formula to handle multiple situations.
Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5). current formula will return “227” with example below:
|Cur Ave||Gms||Total Pins||High Gm||High Series||Ent. Ave|
C5 = #Games, G5 = Entering average, B5 = Current Average
Additionally, I need to have the formula recongize if the # of game is greater than 8 and the Current Average is more than 10 pins below the entering average, use the Entering average minus 10.
When the above is true the return value would be “217”