If condition

[tango]

Appreciate if somebody could help me find a proper "If" or whatever appropriate function/formula with several conditions following the requirement as commented (desc column) in the attached file. Please refer to the attached the file for better understanding please. Thank you for your help.

 

[bosco_yip]

Perhaps………

D4, copied down :

=IF(B4="","No Order",IF(AND(B4<C$1,C4>=C$1),"Over Due",IF(B4<=C4,"In Time","Late")))

Regards
Bosco

 

[tango]

Thanks a lot Bosco. It works....

 

[tango]

Hi, additional request with similar issue as I modified the requirement by adding a new "No Order" comment. I need formula/function please. Attached is the file for your reference. Thanks for your help.

 

[bosco_yip]

Hi, additional request with similar issue as I modified the requirement by adding a new "No Order" comment. I need formula/function please. Attached is the file for your reference. Thanks for your help.

Perhaps…….

In E2, copied down :

=IF(B2="","No order",IF(D2>C2,"overdue",IF(B2<=C2,"intime","late")))

Regards