=IF(OR(AND(A2="BLUE",B2<=D2),AND(A2="RED",C2<=D2)) ,"Yes","No")

--
Best Regards,

Luke M
"LJ" wrote in message
...
A B C
D E
Color Total Time Total Time 2 Time Allowed Y/NO
BLUE 1:22:33 2:22:33 1:00:00
BLUE 2:22:33 3:22:33 2:00:00
BLUE 3:22:33 4:22:33 3:00:00
BLUE 4:22:33 5:22:33 4:00:00
BLUE 5:22:33 6:22:33 5:00:00
RED 6:22:33 7:22:33 6:00:00
RED 7:22:33 8:22:33 7:00:00
RED 8:22:33 9:22:33 8:00:00

I need an IF formula that:

- will read IF condition in the A column is Blue it will bring back a
yes or no response in the E column based on whether the total time in
column B is less than or greater than the time allowed in column D;

- it also needs to read IF condition in the A column is Red it will
bring back a yes or no response in the E column based on whether the
total time in column C is less than or greater than the time allowed
in column D;

Thanks in advance.

LJ