alsmonkeymagic
New Member
- Joined
- Nov 2, 2019
- Messages
- 2
Hi
I am trying to write a formula that will work out scores for me based on a set of predictions against foot ball scores - I have set out the table below. For each correct result, so for example you predict a 1-0 win and its a 2-1 win you get 1 point. For each correct result and score, so for example you predict a 1-0 win and its a 1-0 win you get 3 points. Also each week you can choose 1 game that you want to double your points on, so if you get the result right 2 points and a correct score and result 6 points. I just cannot seem to get my head around it, any help, please!!! I am using Excel 2016.
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I am trying to write a formula that will work out scores for me based on a set of predictions against foot ball scores - I have set out the table below. For each correct result, so for example you predict a 1-0 win and its a 2-1 win you get 1 point. For each correct result and score, so for example you predict a 1-0 win and its a 1-0 win you get 3 points. Also each week you can choose 1 game that you want to double your points on, so if you get the result right 2 points and a correct score and result 6 points. I just cannot seem to get my head around it, any help, please!!! I am using Excel 2016.
A | B | C | D | E | F | G | H | I |
Actual Result | Prediction | Double points | Points Scored | |||||
Bournemouth | v | Man Utd | 0 | 3 | 0 | 3 | Y | 6 |
Arsenal | v | Wolves | 2 | 1 | 3 | 1 | 1 | |
Aston Villa | v | Liverpool | 1 | 1 | 2 | 1 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>