IF formula when field "contains" select text

I have a Multiple Select field that has several choices, like Camp, Membership, Donation. I want to create a Formula field that says Member or Nonmember. I know how to make an IF question for blank fields, but not for a specific Select from a field. I tried just IF(Field = “Member”), “Member”, “Nonmember”), but that doesn’t work.

Use the FIND() function for this use case:

IF(FIND("Member", Field), "Member", "Nonmember")

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.