Previous Topic Next Topic

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
Related:

8 replies

Answer 1 / 8
Ant
Jun 1, 2010 at 10:18 AM
Hi Rizvisa1, can you help me again with this? Could really do with the answer today by 5pm.

Thanks
0
Answer 2 / 8
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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"))
0
Answer 3 / 8
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
0
Answer 4 / 8
seeBlack
Jun 1, 2010 at 05:40 PM
col e col d
row 20 5/4/2010 4/29/2010 -5 =IF(E20-D20<-6,"late","on time")
0

Didn't find the answer you are looking for?

Ask a question
Answer 5 / 8
Ant
Jun 2, 2010 at 03:19 AM
Also can you add if it equals 0 is on time. thanks
0
Answer 6 / 8
Ant
Jun 2, 2010 at 03:22 AM
sorry I think it works... Thanks very much
0
Answer 7 / 8
Ant
Jun 2, 2010 at 03:30 AM
ok, going with Netscur's formula, if possible can you add:

AND IF O7 = 3000, PUT "IGNORE"
Thanks
Ant
0
Answer 8 / 8
Ant
Jun 2, 2010 at 03:39 AM
think i have done it...
=IF(O7=3000,"Ignore",IF(M7<-5,"Late",IF(M7>3,"Late","On Time")))

Thanks everyone,
0