Score predictor in excel help??
Closed
alandiamond
-
May 27, 2010 at 07:34 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 05:08 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 05:08 PM
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
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
Related:
- World cup predictor excel
- Ai lottery predictor - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Fifa world cup 2023 game free download for pc - Download - Sports
- Number to words in excel - Guide
- Gif in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 27, 2010 at 05:08 PM
May 27, 2010 at 05:08 PM
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 ?
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 ?