View Single Post
Old 08-03-2018, 05:31 PM   #54
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default

Quote:
Originally Posted by Calgary14 View Post
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.
firebug is offline   Reply With Quote