Solved/Closed
Ant - Jun 1, 2010 at 09:35 AM
Ant - Jun 2, 2010 at 03:39 AM
Hello,

Date 1 Date 2 Days varience Status
04/05/2010 29/04/2010 -5 On Time
04/05/2010 06/05/2010 2 On Time
07/05/2010 30/04/2010 -7 Late

If Days varience is less than or equal to 5 days before or up to 3 days after, put "On Time", "Late"

This is how I would have done it but its wrong...

=IF(M7<0>=-5>=0<3,"On Time","Late")

Thanks

Ant

8 responses

Hi Rizvisa1, can you help me again with this? Could really do with the answer today by 5pm.

Thanks
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 1, 2010 at 12:29 PM
See if this is what you want

=IF(AND(C2>=-5,C2<=3), "On Time", "Late")

OR

=IF(C2="", "", IF(AND(C2>=-5,C2<=3), "On Time", "Late"))
Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012
Jun 1, 2010 at 12:35 PM
Assuming your Varience is located in cell M7, try this:

=IF(M7<-5,"Late",IF(M7>3,"Late","On Time"))

-Netscur
col e col d
row 20 5/4/2010 4/29/2010 -5 =IF(E20-D20<-6,"late","on time")

Didn't find the answer you are looking for?