Hi,
I'm setting up a competition at work for the upcoming Euros and looking to make my life a little bit easier when running it.
It's a score prediction game and the below are the scoring rules we're using:
3 points - Outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 2 - 0 Turkey v Italy, this would result in 3 points as the person got the correct outcome in picking Turkey to Win).
5 points - Team Score Correct (I.e. Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 0 Turkey v Italy, this would result in 5 points as the person got the correct outcome in picking Turkey to Win but also how many goals Turkey would win).
7 points - Correct Score (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 1 Turkey v Italy, this would result in 7 points as they've correctly picked the correct final score).
0 points - Incorrect outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 0 - 2 Turkey v Italy, this would result in 0 points as they've incorrectly picked the correct final outcome).
Is there any quick way of doing a formula which could populate the points column?
I've attached a sample spreadsheet.
Thanks,
MW
Bookmarks