Hi,
New here, so apologies if my explanation is not great:
I am trying to get the following results
IF A1 = "black" or "white"
AND
IF B1 - "yellow" or "red" or "blue"
results:
TRUE= yes
FALSE = blank
Cells A1 and B1 can have numerous varying text in there, but i want a result if they both contain the corresponding text above at the same time.
Thanks in advance!
New here, so apologies if my explanation is not great:
I am trying to get the following results
IF A1 = "black" or "white"
AND
IF B1 - "yellow" or "red" or "blue"
results:
TRUE= yes
FALSE = blank
Cells A1 and B1 can have numerous varying text in there, but i want a result if they both contain the corresponding text above at the same time.
Thanks in advance!