IF Formula with Contains

[insomned]

Hello, 

Is it possible to write an IF formula with "contains", so if the column X contains "Hello" output "Yes" in the new column? 

Thanks! 

[Emil_Kos · Accepted solution]

Hi @insomned,

This is the formula that you are looking for:

IIF(Contains([Column X], 'Hello'), 'Yes', 'No’)

[insomned]

Thank you!!