excel commands

[MarkusSK]

i have set up my excel spreadsheet in such a way as to check the odds 5min before ok to see if they have shortened. i have put the early morning price in a spare cell and then set the formula to check it. =IF(AND(F4<= TIME(0,5,0), F4> 0, G9< G13), "BACK", "")
Now apparently that formula should say back or nothing. i have trialled it but it isn’t recognising whether G9 <G13 properly as regardless of whether it was or not ( last bet done G9 was 1.47 and I had inputted 1.46 this morning into G13 so technically it should not have placed the bet.

any clues?

also i had the ov 1.5 market on sheet 2 ready to fire on the answer to the above by copying and pasting the link into the command space on sheet 2. i tested that to ensure that if back was on the o2.5 sheet it would appear on the 1.5 which it did but it didn’t fire.

any help be appreciated

[Lewis_c]

I've never used the time function, always converted the minutes into seconds with the following formula in G4
=IFERROR(INT(F4*86400),0)

Then I adjusted your formula to read =IF(AND(G4>0,G4<=300,G9<G13),"BACK","")

where the 300 is just 5mins converted into seconds.