IF Cell Not Empty

Solved
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

5 answers

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