Hi all, Looking for some help with a formula that allocates 3 points for a predicting Home Win, Away Win or Draw, but also allocates 6 points should the person predict the correct score, in the instance below Susan predicted 3-3, which was correct, in turn gets a total of 9 points, 3 for predicting draw and 6 for correct score. Much obliged JJSB
<tbody>
</tbody>
Name | Matches | Predicted Score | Actual Score | Points | |||||
John | Russia | Saudi Arabia | 1 | 0 | 3 | 3 | 0 | ||
Jim | Russia | Saudi Arabia | 1 | 0 | 0 | ||||
Peter | Russia | Saudi Arabia | 2 | 0 | 0 | ||||
Mary | Russia | Saudi Arabia | 3 | 0 | 0 | ||||
Susan | Russia | Saudi Arabia | 3 | 3 | 0 | ||||
Paul | Russia | Saudi Arabia | 2 | 1 | 0 | ||||
Mel | Russia | Saudi Arabia | 3 | 2 | 0 | ||||
Connor | Russia | Saudi Arabia | 4 | 2 | 0 |
<tbody>
</tbody>
Last edited: