Quote Originally Posted by tigertiger View Post
try

=IF(AND(C2>A2,C2<B2),"Yes","No")

or (depend on your need)

=IF(OR(C2>A2,C2<B2),"Yes","No")
Aha! This one did the trick, i made one adjustment to your "and" formula and it did exactly what i needed it to (i didn't know (and( existed!)

=IF(AND(C2>=A2,C2<=B2),"Yes","No")

Thank you very much.

Ron sadly median didn't do what i need it to , what i needed to do was make it identify if the Delivery Time fell between the Early Appointment and Late Appointment time to flag if it was late or not, so tiger's did exactly what i needed. Thank you both for your assistance