Help with formula to add addtional rules. IF formula

[MattGee]

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:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]Cur Ave
[/TD]
[TD]Gms
[/TD]
[TD]Total Pins
[/TD]
[TD="width: 38, bgcolor: transparent"]High Gm
[/TD]
[TD="width: 47, bgcolor: transparent"]High Series
[/TD]
[TD="width: 38, bgcolor: transparent"]Ent. Ave
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]201
[/TD]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]804
[/TD]
[TD="bgcolor: transparent"]217
[/TD]
[TD="bgcolor: transparent"]804
[/TD]
[TD="bgcolor: transparent"]227
[/TD]
[/TR]
</tbody>[/TABLE]

C5 = #Games, G5 = Entering average, B5 = Current Average

Additionally, I need to have the formula recognize 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”

Thanks for any help you can provide.

 

[Joe4]

Welcome to the Board!

Try this:

=IF(AND([COLOR=#333333]Indiv!C5>8,[/COLOR][COLOR=#333333]Indiv!B5+10<[/COLOR][COLOR=#333333]Indiv!G5),[/COLOR][COLOR=#333333]Indiv!G5-10,[/COLOR][COLOR=#333333]IF(Indiv!C5<8,Indiv!G5,Indiv!B5))[/COLOR]

 

[Max1616]

Try this:
=IF(C5<8,IF(B5<(G5-10),G5-10,B5))

 

[MattGee]

Thank you for the assistance, this worked. modified a few things but it worked. I appreciate the help.

 

[MattGee]

Thank you this worked also. I appreciate the help!