Can I use 'CONTAINS' in an IF Logical Test?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichaelRobert - 20 Sep 2007 18:10 GMT

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

Reply to this Message

JE McGimpsey - 20 Sep 2007 18:15 GMT

One way:

=IF(COUNTIF(Q2,"*RED*"),"Yes","No")

another:

=IF(ISERR(SEARCH("RED",Q2)),"No","Yes")

> 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
[quoted text clipped - 11 lines]
>
> Mike

Reply to this Message

MichaelRobert - 20 Sep 2007 18:58 GMT

Works like a charm. Many thanks.

> One way:
>
[quoted text clipped - 19 lines]
> >
> > Mike

Reply to this Message