I have a formula set up to tell me if a goal is scored in the 2nd half of a match. Cells C2:J2 contain blank cells for me to input goal times for the home team and cells M2:T2 for the away team.

So for example if the home side won the game 2-1 with goals scored in 25, 33, and 56 minutes then the formula would return a 1 in the target cell. If there was no goal in the 2nd half then a 0 would be returned. The 25 would be in cell C2, 33 in cell M2, and 56 in cell D2. The rest of the cells are left empty.

The working formula I have is =IF(OR(C2:J2>45,M2:T2>45),1,0) but this is returning #VALUE! in the target cell, if I click the function wizard the formula is working.

Basically I'm not sure why the formula is returning #VALUE! so if anyone knows why that would be great. I've attached a sample file.

Sample file.xlsx