Can I use 'CONTAINS' in an IF Logical Test?
One way:
=IF(COUNTIF(Q2,"*RED*"),"Yes","No")
another:
=IF(ISERR(SEARCH("RED",Q2)),"No","Yes")
In article ,
MichaelRobert wrote:
I want to use the IF function, but using a Logical Test on a given cell that
contains text, like 'Red; Green; Blue'. The cell may contain all, none, or
any of these words. If the cell contains Red, I want to Return Yes
My Function would look something like
=IF (Q2 CONTAINS "RED", "Yes", "No")
However, I only see IF working on numbers and not text.
Any ideas?
Thanks.
Mike
|