Help with score predictor game

Hi Clever People

Im very new to excel formulas(3 days) and I need some help.
I want to create a score prediction spreadsheet that calculates the following parameters

4 Points for exact score
3 Points for predicting a draw
2 Points for Correct result closest to score
1 Point for wrong result closest to score

So far I've worked exact score and draw, Ive even managed to work out ranking but nesting margins to this has me stumped

This is what I came up with so far

=IF(COUNT($N$8:$O$8;P13:R13)=4;IF(AND($N$8=P13;$O$8=R13);4;IF(OR(AND($N$8>$O$8;P13>R13);AND(R13>P13;$O$8>$N$8);AND(R13=P13;$O$8=$N$8));3;0));"")

Ive been at this for hours.

Any help would be greatly appreciatedpredictor example.xlsx

What are your expected results, calculated manually?

That's a formula - I asked for expected results (i.e.values) calculated manually.

If you already have a formula, then why do you need help? Very confusing ...

I'll try to help if you provide what I've asked for.

OK - thanks. I'll have another look later (just waiting for the groceries to arrive).

Your explanation seems to bear no resemblance to what is in your sheet. I cannot see 20-16 ANYWHERE in the sheet.

Please repost the file, showing WHAT you want to see WHERE you want to see it and explan HOW you (manually) derived the expected results.

Just looked - I concur with Glenn.

You are leaving far too much to our imagination, and sadly, wa are not clairvoyant.