Quote:
Originally Posted by Calgary14
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
|
You can nest if statements: "if (red then yes, if (green then yes, no)) would be your example. If the cell is red the answer is yes, if not then if the cell is green the answer is yes, if not then the answer is no.