If statements with text?

I want to build an if statement that evaluates cells with text; tom, bob, gene | Team 1 tom, gene | Team 1 bob | Team 2 gene | Team 1 tom, bob | Team 2 Basically =if(a1 CONTAINS "gene", "Team 1", "Team 2") So if Gene's name shows up anywhere in a cell in col A, I'll get Team 1 in col B; if it doesn't, I get Team 2 in col B. ???

• › Excel If statement w/ text values from range
• › IF statements with VLOOKUP
• › If statements with cells containing text
• › [Solved] If Statement with a third condition
• › Excell using If Statement with Named Columns
• › formulate if then conditions with text . date
• › [Solved] IF statement with Vlookup - get rid of #N/A