Football predictions v Actual score

[Axdby]

G7 contain home team goal prediction. H7 contains Away Team goal prediction
iI7 contains actual home team goals. J7 contains actual away team goals.

I need a formula to return a value of 5 or “-“ in N7 only iF a score has been entered in H7;& J7 and:

A) the correct outcome of a game matches the predicted score
B) the correct outcome of a game is predicted, even if the score is different

However, all formulas I have tried return a value of 5 if no figure is entered in I7 & J7, and the predicted figure in G7 & H7 is for a draw (0-0, 1-1, 2-2 etc) I don’t want this to happen

 

[Axdby]

Sorry, forgot the image of layout

 

[Snakehips]

@Axdby Sadly, for me at least, your logic / requirement is not clearly defined.
So all I can offer is the below in the hope that it might be of value.
If not perfect it may help you progress?
Column O is returning 5 for a correct score or 3 for correct result.
Column N is returning 5 for both???
Maybe you can adapt to give the returns you need?
If I am way off the mark then please try and illustrate exactly what you are wanting.

Book1
	G	H	I	J	K	L	M	N	O
5	Prediction		Actual
6	Home	Away	Home	Away				????	???
7	3	1	2	1				5	3
8	3	1
9
10	2	6	2	6				5	5
11	2	6
12	3	2	2	7				-	-
13	3	1	3	1				5	5
14	1	1	0	0				5	3
Sheet1

Cell Formulas
Range	Formula
N7:N14	N7	=IF(COUNTA(I7:J7)<2,"",IF(OR(AND(G7=H7,I7=J7),AND(G7>H7,I7>J7),AND(G7<H7,I7<J7)),5,"-"))
O7:O14	O7	=IF(COUNTA(I7:J7)<2,"",IF(AND(G7=I7,H7=J7),5,IF(OR(AND(G7=H7,I7=J7),AND(G7>H7,I7>J7),AND(G7<H7,I7<J7)),3,"-")))

 

[Axdby]

G7 contain home team goal prediction. H7 contains Away Team goal prediction
iI7 contains actual home team goals. J7 contains actual away team goals.

I need a formula to return a value of 5 or “-“ in N7 only iF a score has been entered in H7;& J7 and:

A) the correct outcome of a game matches the predicted score
B) the correct outcome of a game is predicted, even if the score is different

However, all formulas I have tried return a value of 5 if no figure is entered in I7 & J7, and the predicted figure in G7 & H7 is for a draw (0-0, 1-1, 2-2 etc) I don’t want this to happen

@Axdby Sadly, for me at least, your logic / requirement is not clearly defined.
So all I can offer is the below in the hope that it might be of value.
If not perfect it may help you progress?
Column O is returning 5 for a correct score or 3 for correct result.
Column N is returning 5 for both???
Maybe you can adapt to give the returns you need?
If I am way off the mark then please try and illustrate exactly what you are wanting.

Book1
	G	H	I	J	K	L	M	N	O
5	Prediction		Actual
6	Home	Away	Home	Away				????	???
7	3	1	2	1				5	3
8	3	1
9
10	2	6	2	6				5	5
11	2	6
12	3	2	2	7				-	-
13	3	1	3	1				5	5
14	1	1	0	0				5	3
Sheet1

Cell Formulas
Range	Formula
N7:N14	N7	=IF(COUNTA(I7:J7)<2,"",IF(OR(AND(G7=H7,I7=J7),AND(G7>H7,I7>J7),AND(G7<H7,I7<J7)),5,"-"))
O7:O14	O7	=IF(COUNTA(I7:J7)<2,"",IF(AND(G7=I7,H7=J7),5,IF(OR(AND(G7=H7,I7=J7),AND(G7>H7,I7>J7),AND(G7<H7,I7<J7)),3,"-")))

Thank you for your help. The first of your two formulas produced the correct return value