IF Statement Required please

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")

Help Please....

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")
Also can you add if it equals 0 is on time. thanks
sorry I think it works... Thanks very much
ok, going with Netscur's formula, if possible can you add:

AND IF O7 = 3000, PUT "IGNORE"
Thanks
Ant
think i have done it...
=IF(O7=3000,"Ignore",IF(M7<-5,"Late",IF(M7>3,"Late","On Time")))

Thanks everyone,