Football formula

[oxerife]

Hello everyone,

Can anybody help me with the following formula?

I want to know if a specific selection is within a range, 5 minutes before the off and save it to a cell.

Example: If Under 2.5 goals is bigger than 2.10 then C45 = "Y" else "N"

Thanks

[osknows]

Hi oxerife,

Assuming the Under 2.5 goals back odds are in cell F5

Then in cell C45

=IF(AND(F5>=2,F5<=5),"Y","N")


this reads, if F5 is greater or equal to 2 AND less than or equal to 5 then C45 equals Y else N.

You just need to change F5>=2,F5<=5 to suit your needs

Os

[osknows]

sorry I forgot about the 5minutes before the start

put this in any unused cell to give the time before off in seconds

=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))

then assuming that formula is in cell Q1...

in cell C45

=IF(AND(F5>=2,F5<=5,Q1=300),"Y","N")

This will only turn Y for 1 second when Q1=300, if you want to introduce a window of say 5 seconds you could use

=IF(AND(F5>=2,F5<=5,Q1<=300,Q1>=300-5),"Y","N")

[oxerife]

sorry I forgot about the 5minutes before the start

put this in any unused cell to give the time before off in seconds

=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))

then assuming that formula is in cell Q1...

in cell C45

=IF(AND(F5>=2,F5<=5,Q1=300),"Y","N")

This will only turn Y for 1 second when Q1=300, if you want to introduce a window of say 5 seconds you could use

=IF(AND(F5>=2,F5<=5,Q1<=300,Q1>=300-5),"Y","N")

Thanks for your reply