If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF Multiple Conditions
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 |
#2
|
|||
|
|||
IF Multiple Conditions
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(d2b2,"yes","no")) =if(a2="red",if(d2c2,"yes","no")) Regards, Fred "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 |
#3
|
|||
|
|||
IF Multiple Conditions
=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 |
Thread Tools | |
Display Modes | |
|
|