Hi guys, I am new to this, and fairly average at Excel.
I have created a game for World Cup predictions where you get points i.e.:
Guess the correct result only: 2 points
Guess the correct amount of goals each team scores: 1 point per team
Guess the correct score exactly: 5 points
Wrong result and score: 0 points
So if I had the actual correct score in cells A1 & B1, and my predictions started in cells A2 & B2 etc, how would I calculate that?
Thanks in advance.
Bookmarks