Excel Formula Help

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
201 4 804 217 804 227

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”

By: Matt

Leave a Reply

Your email address will not be published. Required fields are marked *