Hi,
Me and my colleague bet football games, it looks like in the picture attached.
Our rules are simple:
What I've figured out so far is how to add 3 points for a correct score:
The sum of all points would be located in cell G6 and I6 respectively.
I'm not sure how to modify the IF formula to include 1 and 0 points awards.
Any help would be appreciated.
Regards,
Sojek
Me and my colleague bet football games, it looks like in the picture attached.
Our rules are simple:
- correct score = 3 points
- Someone guess the winner but with no correct score: 1 points
- No guess: 0 points
What I've figured out so far is how to add 3 points for a correct score:
Code:
=IF(AND(D4=G4,E4=H4),3,0)
The sum of all points would be located in cell G6 and I6 respectively.
I'm not sure how to modify the IF formula to include 1 and 0 points awards.
Any help would be appreciated.
Regards,
Sojek