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