Changing single select to Multi-select

[Solomon12345]

I am trying to write an IF function such that the condition in the statement is to look for the presence of a particular word in a multi-select column. If the word is present in the multi-select, the value-if-true should be displayed. 

In a multi-select column, there is a list of amenities: Airconditioning, Lounge, Studio, etc. I want to create a new formula column that looks for "Studio" in the multi-select column. If it is present then show Yes, if it's not show "No". Something like this: IF(Amenities="Studio", "Yes", "No"). This gives me the correct output if the only value selected is Studio. In the case where the column has "Lounge" and "Studio", I get No as the output.

[Adrienne_Medina · Accepted solution]

You can use a Find function for this:

IF(FIND("Studio", {Field}), "Yes","No")

[Solomon12345]

Thank you. It works!