Hi,

I have the following criteria to asses match results

Away loss by 7 points or more = 0 points
Away loss by 6 points or less = 1
Away draw = 2
Away win by 1 to 6 points = 3
Away win by more than 7 = 4

I used the following equation:
=IF(E2="","",IF(D2-E2<=6,1,IF(E2=D2,2,IF(E2-D2=7,4,IF(E2-
D2<7,3,0)))))

Seemed to mostly work, apart from the last bit. I think I have the
last zero in the wrong place.

This formula if the score was 50-40 (D2=50, E2=40) home win, evaluated
E2-D2<7 as -10 and put 3 in the cell

Thanks for any help

Neil