Return a certain value if partial text is found on another cell

Joao Lima

Hello guys, I've been struggling to find a good formula for this case. Basically I have one column with different text (Band 5 RN, Band 6 RN and Band 2 HCA) and I want to create a new column that returns "Nursing" when the cell contains the text RN and to return "Other" when it doesn't.

Anyone with a correct formula? I've tried IF(CONTAINS) without success. Thanks!

Paul Newcome

Try this:

=IF(CONTAINS("RN", [1st Column Name]@row), "Nursing", "Other")

Joao Lima

Thank you Paul, I actually went around and used an IF(FIND()...