Is it possible to have multiple IF/THEN statements in one cell? If I wanted to search a row of cells for the terms red, green and blue and then classify them based on their color - what would that formula look like? For example "if red, then yes", "if green, then yes" and "if blue, then no" - can I do that all in one cell? Right now I can only seem to put one if/then statement in there
|