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,




1 Reply


In O1:




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


This can be filled down if required.