Score predictor in excel help??

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi

I am doing a world cup predictor spreadsheet in excel. How do I match scores and assign points in excel?

eg. If someone predicts england to beat usa 2 - 1 then I want to assign them 4 points but if they beat them 3-1 i only want to assign them 1 point(the correct score must be got in order to get full points). any other result (usa win or a draw) would mean the person gets 0 points.

Its probably quite simple to do but i just cant seem to get my head round it.

Thanks
Al

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Why predict ? Germany is getting the cup, though I am hoping for some South American country to pick it. Just you wait and see :P

Are you saying that
if score is predicted 100% its 4 point
If the result is predicted correctly but by wrong score, its 1 point
and if result is wrong then 0 point?

Could you add a sample file ?