AND IF functions

Occasional Visitor

Hello there,

 

I have a problem with Excel.

 

This is what I want:

If cell I1 contains the word "information" or "systems" then I want in cell O1 'yes'.

If cell I1 does not contains one of these words then I want in cell O1 'no'.

 

Cell I1 contains a lot of words. It is a description of a certain job. 

When I try to use the IF/AND function it always says 'no' because "information" of "systems" is not the only word in cell I8.

 

Thank you in advance,

Inge

 

 

1 Reply

@ingevanwalstijn 

In O1:

 

=IF(OR(ISNUMBER(SEARCH({"information","systems"},I1))),"yes","no")

 

(If you use comma as decimal separator, replace , with ; in the formula)

 

This can be filled down if required.