Shaun,

this will correct the calculation for Situation 1:

=IF(AND((Cell2-Cell1)<=7,(Cell2-Cell1)0),1,0)

I think the formula for Situation 2 is correct, unless I have
misunderstood. If a team scores 6 tries do they get 1 or 3 bonus
points?

Pete