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 could also use conditional formatting to highlight cells with specific text in them and then you wouldn't need additional cells with formulas in them.
If in a table, you can even sort by cell or text colour.
__________________
"Teach a man to reason, and he'll think for a lifetime"
~P^2
Last edited by firebug; 08-03-2018 at 05:35 PM.
|