Forum Discussion
AND IF functions
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
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.
