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. ???

• › [Solved] How to do an IF statement with multiple dates and criteria
• › [Solved] IF statements with nested Vlookups
• › [Solved] #NAME error - calling data from cell w/IF formula with text
• › [Solved] How to use and IF statement with REPLACE
• › [Solved] Excel IF statement with date doesn't work for me
• › [Solved] Adding If statement for different strbody
• › what is wrong with this If Statement? thnak you