Formulas required for football prediction game

Hi, I am looking for help to get the correct formulas to produce the required results on my Football Tournament game.

Hi and welcome

In row 14, why is there not a 1 under the "Home Goals" column? The prediction and the actual match.

BSB

Sorry, I forgot to include column details in my post

Home goals L7
Away goals M7
Correct outcome (W-L-D) N7
Exact score O7

My error, I manually typed in numbers for illustration purpose

See attached.
Does that work for you?

BSB

File adjusted to put the cells as you describe in post#3 so you can lift and shift the formulas to your workbook.

BSB

Thank you! The formula produces the correct return value on games which have an actual score entered. However, it also return values of 1 in column M & 5 in colum pin N where no actual score has been entered

I'm not sure what you mean.

Could you post the example file back highlighting the cells that are incorrect and explaining what they should be?

BSB

Hi, I don’t know what I did wrong, but I retyped the formulas, and cell L7, M7, N7 &O7 all,produce the correct result, if an actual scor was entered., if no score was entered, the cell remained blank.

Thank you for all your help.