I have a formula in which for all intensive purporses was going great.........

Until I ran into a slight problem.

As I have posted in other threads trying to get help (though I worked it out on my own in the end), I am doing a soccer prediction league and wanted to run things smoothly.

Here is my formula:

=IF(I3="","",IF(AND($H$2=H3,$I$2=I3)=1,5,IF(AND($H$2>H3,$I$2>I3,$H$2=H3)=1,4,IF(AND($H$2<H3,$I$2<I3,$H$2=H3)=1,4,IF(AND($H$2>H3,$I$2>I3,$I$2=I3)=1,4,IF(AND($H$2<H3,$I$2<I3,$I$2=I3)=1,4,IF(AND($H$2>H3,$I$2>I3)=1,3,IF(AND($H$2<H3,$I$2<I3)=1,3,IF(AND($H$2=$I$2,H3=I3)=1,3,IF(AND($H$2>H3,$I$2<I3,$H$2=H3)=1,1,IF(AND($H$2<H3,$I$2>I3,$H$2=H3)=1,1,IF(AND($H$2>H3,$I$2<I3,$I$2=I3)=1,1,IF(AND($H$2<H3,$I$2>I3,$I$2=I3)=1,1,IF(AND($H$2>$I$2,H3=I3,$H$2=H3)=1,1,IF(AND($H$2<$I$2,H3=I3,$H$2=H3)=1,1,IF(AND($H$2>$I$2,H3=I3,$I$2=I3)=1,1,IF(AND($H$2<$I$2,I3=H3,$H$2=H3)=1,1,IF(AND($H$2=$I$2,H3>I3,$H$2=H3)=1,1,IF(AND($H$2=$I$2,H3<I3,$H$2=H3)=1,1,IF(AND($H$2=$I$2,H3>I3,$I$2=I3)=1,1,IF(AND($H$2=$I$2,I3<H3,$H$2=H3)=1,1,0)))))))))))))))))
I realise its a lot of ifs and ands but it was doing the job.

formula help.png

Above is a copy of the spreadsheet. In column G I write the scores manually as 2-1 etc, but in column H and I I use =IF(G3="","",LEFT(G3,FIND("-", G3)-1)) to seperate them (use right for I).

The above IF and AND formula is in column J to calculate the points earned.

My issue is, the game finished 0-0, and all the ones with 1 points are correct as although they predicted the wrong outcome, they at least got 1 teams amount of goals correct. However the players that got 3 points are clearly wrong. They didn't predict a draw nor did they get a teams goals right.
If I changed one of the teams results to 2-0, then they are changed to 1 point. If I change the actual score to 1-1 (G2) instead of 0-0, the all the scoring wins still get 3 points. Only seems to occur to games where both teams score, and a win is determined.

I'm sorry if I don't make any sense, but this is really bugging me now.