Football result formula for awarding points

Hi There,

I am drawing up a spreadsheet for a football results competition and devising a formula that will award 3 points for predicting the correct score, 1 point if the correct result is predicted and 0 points if both are wrong. The score in red is the actual score and then underneath are everyone's predictions for that game.

I am using this formula at present which seems to be working, however there are a couple that it is not working for.

=IF(AND(D9=$D$7,E9=$E$7),3,IF(OR(D9-E9=$D$7-$E$7,AND($D$7>D9,$E$7>E9),AND($D$7>D9,$E$7>E9)),1,0))

Any ideas would be gratefully appreciated!

Many thanks,

Excellent! Thank you very much

That formula will work if the last AND argument's angle brackets are reversed. As it's written now it's redundant because the relative values of "E" column values are being compared as less than column "D" values.

Once corrected the formula will correctly report scores for winners in either column.