Caporegime
Hi all
We've got a World Cup results prediction spreadsheet, whereby you get one point for guessing correct number of home goals, one for correct number of away goals, and one for the correct result.
My prediction is in the first section, the actual results are in the second section, and the number of points scored I want to be automatically calculated when the game's result is entered.
For the correct number of goals for each team, I've just done =IF(AND and it works fine. However, I can't work out a formula that will check whether the result was guessed correctly, whether win lose or draw.
For example, if I had South Africa to draw 1-1 with Mexico and the score was actually 2-2, I'd get no points for number of goals but one point for guessing a draw. It's the last part I can't figure out.
Thanks!
Edit - to hopefully make it more obvious what I mean:
We've got a World Cup results prediction spreadsheet, whereby you get one point for guessing correct number of home goals, one for correct number of away goals, and one for the correct result.
My prediction is in the first section, the actual results are in the second section, and the number of points scored I want to be automatically calculated when the game's result is entered.
For the correct number of goals for each team, I've just done =IF(AND and it works fine. However, I can't work out a formula that will check whether the result was guessed correctly, whether win lose or draw.
For example, if I had South Africa to draw 1-1 with Mexico and the score was actually 2-2, I'd get no points for number of goals but one point for guessing a draw. It's the last part I can't figure out.
Thanks!
Edit - to hopefully make it more obvious what I mean:
Last edited: