What if I need a "contains" command instead of an = ?

=IF([Package Status]="Further Clarification","Yes","No")


You could try the FIND formula for this one.

e.g. Check if "ABC" contains "A"


For more details, check out this link.


I have edited your given formula to get the desired result:

=IF(ISERROR(FIND("Further Clarification",[Package Status])),"No","Yes")

Explanation: Above formula will first find the "Further Clarification" in the column called "Package Status". If this find results in an error (that is, the String is not in the column/data does not exist) it will return "No". Otherwise, the String exists in the column, so it returns "Yes".

Ask me for further information.

  • Have you tried above solution given in my answer? is that works for you?
    – Hardik
    Jun 30 '16 at 7:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.