Hi. I do a football prediction competition at work and need help or the formula to calculate peoples scores.

The scoring works like this

10 points for a completely correct result and score for both teams e.g. 1-0 prediction and 1-0 result
7 points for a correct result but a correct score for only 1 team e.g. 1-0 prediction and 2-0 result
5 points for a correct result but no correct score for either team e.g. 1-0 prediction and 2-1 result
2 points for an incorrect result but a correct score for 1 team e.g. 1-0 prediction and 1-2 result

I have basic Excel knowledge but have no idea how to create a formula which will calculate the above and populate the correct scores for people in the spreadsheet.

Please can anyone help. I can provide the spreadsheet that I have created which is only missing this formula.

Many thanks in advance.