EURO 2024 Predictions v Actual score

[Axdby]

Cells G1 & H1 are the predicted score. I1 & J1 the actual score. If game finishes with a different score but with the same outcome (Win, Draw or Loss):what is the formula to indicate if I have predicted the correct outcome of a match in N1

 

[Fluff]

Another option

Fluff.xlsm
	G	H	I	J	K	L	M	N
1	Prediction		Actual					Correct
2	H	A	H	A				W-D-L
3	3	0	3	0				5
4	0	3	0	3				5
5	2	1	1	0				5
6	1	1	2	2				5
7	0	5	2	2				0
8	0	0	0	0				5
Sheet5

Cell Formulas
Range	Formula
N3:N8	N3	=(SIGN(G3-H3)=SIGN(I3-J3))*5

 

[FormR]

I have triied both the formulas suggested ( I have set the format for the cell to “Number”), but both formulas display in the cell when I press enter.

You have a third to try now as well Do you normally use a comma as the list separator in your formulas with your regional settings? Did you change the format of the cell before you entered the formula?

To return a result that includes exact correctly predicted scores, my suggested formula would be adjusted to this.

=IF(OR(AND(G3=H3,I3=J3),AND(G3<H3,I3<J3),AND(G3>H3,I3>J3)),5,0)

 

[Axdby]

FormR - I finally got the formula to produce a result. However, as you will see from my updated sample data, some of the results are incorrect. Any suggestions?

 

[FormR]

some of the results are incorrect

I think you'll need to show us the exact formula you used in that screen shot as the formula I posted in post #12 and the formula from Fluff in post #11 seem to give the results you say you expect.

Book1
	G	H	I	J	K	L	M	N	O
1	Prediction		Actual					Correct
2	H	A	H	A				Post #11	Post #12
3	3	0	2	0				5	5
4	2	1	1	2				0	0
5	2	1	4	0				5	5
6	5	1	4	1				5	5
7	0	1	2	3				5	5
8	0	1	0	2				5	5
9	2	3	0	3				5	5
10	1	1	1	1				5	5
11	1	0	0	4				0	0
Sheet1

Cell Formulas
Range	Formula
N3:N11	N3	=(SIGN(G3-H3)=SIGN(I3-J3))*5
O3:O11	O3	=IF(OR(AND(G3=H3,I3=J3),AND(G3<H3,I3<J3),AND(G3>H3,I3>J3)),5,0)

 

[Axdby]

FormR —— I have now got it working using both your formula and the formula from Fluff. At first when I entered the formulas and pressed enter, the full formula displayed in the cell. What I was doing was copying and pasting your formulas rather than typing them myself. I got it working on Fluff’s formula after I noticed when I copied and pasted, an apostrophe appeared at the beginning of the formula, so I removed it and the formula gave the correct result. I then tried your formula (deleting the apostrophe,,and it also produced the correct result. May i take this opportunity to thank everyone for their suggestions, and help with this. I appreciate it, and also apologise for any confusion I caused. Thank you!

 

[FormR]

Great, glad you got it working