IF Statement Required please Solved/Closed

Question

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

Ant · Answer

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

rizvisa1 · Answer

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 · Answer

Assuming your Varience is located in cell M7, try this:

=IF(M7<-5,"Late",IF(M7>3,"Late","On Time"))

-Netscur

seeBlack · Answer

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

Ant · Answer

Also can you add if it equals 0 is on time. thanks

Ant · Answer

sorry I think it works... Thanks very much

Ant · Answer

ok, going with Netscur's formula, if possible can you add:

AND IF O7 = 3000, PUT "IGNORE"
Thanks
Ant

Ant · Answer

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

IF Statement Required please

8 responses

Similar discussions

Subscribe To Our Newsletter!