Combine Min Max Statement to Calculate 'Goal Differential'

[RockTheRed1]

Hello Excel Guru's... Im trying to develop a soccer standings board. When I calculate the goals against, I need it to be capped at a maximum of '5' regardless how many goals were actually scored for both team.

I have tried the following using MIX MAX statements but I cant get it to calculate both ways, it always give me a +5 or always gives me a -5. I cant figure out how to make it dynamic.

For my example... I need a formula that will populate a maximum differential of 5 in column 'G' and Column 'M'. This '5' will be a positive number for one team, and a negative number for the other team

Appreciate the assist

 

[hagia_sofia]

Hello, maybe:

=IF(ABS(F3-L3)>5,SIGN(F3-L3)*5,F3-L3)