IF Multiple Conditions

[LJ]

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

 

[Fred Smith]

It's unclear whether you want Yes or No if D is greater than B. If I guessed
wrong, you will have to reverse the order in:
=if(a2="blue",if(d2>b2,"yes","no"))
=if(a2="red",if(d2>c2,"yes","no"))

Regards,
Fred

 

[Luke M]

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