how do I join these 2 statements
IF(AND(M2="",L2>=K2),"On Time","Delayed")
IF(OR(M2<=L2,K2>=M2),"On Time","Delayed")
how do I join these 2 statements
IF(AND(M2="",L2>=K2),"On Time","Delayed")
IF(OR(M2<=L2,K2>=M2),"On Time","Delayed")
Maybe
=IF(OR(M2<=L2,K2>=M2,AND(M2="",L2>=K2)),"On Time","Delayed")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
thx for the quick response ! unfortunately the AND portion dos not seem to reign true.
The L2>=K2 statement does not seem to matter - any date in either of those fields brings back an "on time" result
e.g. if K2 = 5/30/13, L2 = 3/12/13 the result is showing as "on time"...should be "delayed"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks