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 thes...
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.