Euro Prediction league formula advice
I am doing a prediction competition however my points are slightly different and i am having trouble working out the formula. In my game, it is still 3 points for the correct score, however it is 1 point for the correct result.
For Example
Predicted Actual
cell A B C C
1 1 1 0 0
2 3 0 3 0
So game 1 would be 1 point as the draw was correctly predicted but the score incorrect.
I cant seemt to get the formula correct for this particular scenario.
Much appreciated if anyone can assist
Kevin
