AND IF functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2354838%22%20slang%3D%22en-US%22%3EAND%20IF%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354838%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I%20want%3A%3C%2FP%3E%3CP%3EIf%20cell%20I1%20contains%20the%20word%20%22information%22%20%3CSTRONG%3Eor%3C%2FSTRONG%3E%20%22systems%22%20then%20I%20want%20in%20cell%20O1%20'yes'.%3C%2FP%3E%3CP%3EIf%20cell%20I1%20does%20not%20contains%20one%20of%20these%20words%20then%20I%20want%20in%20cell%20O1%20'no'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECell%20I1%20contains%20a%20lot%20of%20words.%20It%20is%20a%20description%20of%20a%20certain%20job.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20use%20the%20IF%2FAND%20function%20it%20always%20says%20'no'%20because%20%22information%22%20of%20%22systems%22%20is%20not%20the%20only%20word%20in%20cell%20I8.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3EInge%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.