IF & AND Excel Statment/s - New User Help Needed

[MRV100]

Hi, I've got a problem with an IF/And Statement and do not know if this the correct function to use.

Basically I'm trying to say two things in Cell E2:

IF the date in column C2 is greater than column A2 it is Late, if not its on time AND If the time in column D2 is greater than column B2 it is Late, if not its on time.

So far I've come up with this formula =IF(AND(C2>A2,D2>B2),"LATE","ONTIME")

However the problem I have is that when the dates in Column A2 & C2 both match but the time in Column D2 is greater than the one in Column B2 it is still showing up as ontime when it should be late which is puzzling.

I've tried two IF(And(.. statements back to back as well as standard If statments back to back which didn't work, So i'm confused at the moment

Can anyone help!!

 

[balla506]

What about something like this rather than the and statement...=IF(C2>A2,"late",IF(D2>B2,"late","on time"))

 

[Drrellik]

=IF(OR(C2>A2,D2>B2),"LATE","ONTIME") if you only need one argument to be true to be late then change your AND to an OR.

 

[kevatarvind]

Try below one
=IF(C2&D2>A2&B2,"LATE","ONTIME")

 

[kevatarvind]

What about something like this rather than the and statement...=IF(C2>A2,"late",IF(D2>B2,"late","on time"))

This Will not work when C col Date is Less Then A col and D col time Greater then B col it will show late bcoz 2nd condition met but in this case need to show"ontime"