Getting lots of IFs to work together

[Number_8]

I have a list of football scores in column I and J foor home and awa
results. I have in column N and O my prediction for the scores of thos
matches. I want to be able to award in column P, 1 point if I predic
teh correct winner (i.e. home win, away win, draw) and 3 points if
get the exact score correct i.e. (3-1 in teh real match and 3-1 in m
prediction).

How do I do it?
Thank

 

[Andy Brown]

I have a list of football scores ...

Thank you for calling it "football".

How do I do it?

Brute forcibly. Try

=IF(AND(I1=N1,J1=O1),3,IF(AND(I1>J1,N1>O1),1,IF(AND(I1<J1,N1<O1),1,IF(AND(I1
=J1,N1=O1),1,0))))

, if I've missed a permutation post back highlighting where it falls over.

Rgds,
Andy