IF Cell Not Empty

Thanks to everyone for your responses.
Here is my formula: =IF(ISBLANK(AO2);IF(ISBLANK(AN2);IF(ISBLANK(AM2);"";IF(AM2<TODAY();"Late";"Ordered"));IF(AN2<TODAY();"Late";"Revised Date")); "Delivered")
I would like to add to this formula that if (AP2) is not blank (it is a date that should appear in (AP2), then "Cancelled" should display in (AO2).

If I add IF(NOT(ISBLANK(AP2));"Cancelled";"") I get a #VALUE error...

Best regards,

Beebboo

Hello,

If AP2 without formula: in AQ2---> =IF(ISBLANK(A2);"";"Cancelled")

or more logically

=IF(NOT(ISBLANK(AP2));"Cancelled";"")

Hello

In AQ2 =IF(AP2>0;"Cancelled";"")
To be tested
Regards

Hello Forum

In AQ2 =IF(NOT(ISBLANK(AP2));"Cancelled";"")

Mytå
Thank you for following up on your question, we are not robots...
“If debugging is the art of removing bugs, then programming must be the art of creating them.”