Hi
Can you please help me.
If column D5 ="France" & J5 > 21 DAYS , "Late"
If column D5 ="Germany" & J5 > 14 DAYS , "Late"
If column D5 ="UK" & J5 > 14 DAYS , "Late"
If J5 ="Not collected","Not Collected"
I need a formula that to be used in column K5
Similar
If column D5 ="France" & M5 > 21 DAYS , "Late"
If column D5 ="Germany" & M5 > 14 DAYS , "Late"
If column D5 ="UK" & M5 > 14 DAYS , "Late"
If N5 ="Not sent as yet","Not sent as yet"
See attached and thank you
Bookmarks