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.

| improve this answer | |

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.

| improve this answer | |
  • 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.