IF Cell Not Empty Solved

Question

Hello,

I am looking for the correct formula to say: If (AP2) is not empty then display "Cancelled" in (AQ2)

Thank you in advance for your help,

Best regards,

beebboo

Configuration: Windows 7 / Chrome 39.0.2171.95

Mytå · Answer

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.”

jc80 · Answer

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

f894009 · Answer

Hello,  If AP2 without formula: in AQ2---> =IF(ISBLANK(A2);"";"Cancelled")  or more logically  =IF(NOT(ISBLANK(AP2));"Cancelled";"")

Beebboo · Answer

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

f894009 · Answer

Re,

I see it like this

=IF(NOT(ISBLANK(AP2));"Cancelled";IF(ISBLANK(AO2);IF(ISBLANK(AN2);IF(ISBLANK(AM2);"";IF(AM2<TODAY();"Late";"Ordered"));IF(AN2<TODAY();"Late";"Revised Date")); "Delivered"))

the insertion of this IF(NOT(ISBLANK(AP2));"Cancelled";"") cannot go for the same cell

IF Cell Not Empty

5 réponses

Windows spotlight is not working.

Samsung j5 unable to answer

Scam of the suvedene highway

Remove 360 antivirus

My pc's screen is flickering.

Fujitsu siemens laptop won't start anymore

Wearline: what do you think?

Eko tank smartwatch

Ibiza sound reviews

Only one of my iphone headphones works. what to do?