Search (more than one condition)

[AndyD]

Hi
Can you supply formulae that enables you to return "ok" if a character string doesnt contain this AND also doesnt contain this AND also doesnt contain this etc

this kind of thing doesnt seem to work..
=IF(SEARCH("123",C2),"",IF(SEARCH("abc",C2),"","ok"))

thanks
Andy

 

[Andrew Poulsom]

The SEARCH returns the #VALUE! error if it fails, so:

=IF(ISNUMBER(SEARCH("123",C2)),"",IF(ISNUMBER(SEARCH("abc",C2)),"","ok"))

 

[Aladin Akyurek]

=IF(COUNT(SEARCH({123,"abc"},C2)),"","ok")