#### alsmonkeymagic

##### New Member

- Joined
- Nov 2, 2019

- Messages
- 2

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>