Hi
I am looking for some help creating an excel sheet to keep track of a friends football score predictions.
I need a formula that calculates the outcome of the match once the score is entered (so Home Win, Away Win, Draw) and I also need the following points system:
correct result: 100 points
Correct score: 300 points
Bonus per correct home goal: 15 points
Bonus per correct away goal: 20 points
I have attached my attempt at a lay out but not sure if this is the best way to go about it..
Any help would be much appreciated
Thank you for your time
John
Bookmarks