I have found this command:

=IF(ISERROR(SEARCH("x",A1)),"Z","")

How do you make mulitple arguements? I can't seem to get an =if(or(... function working.

Basically I have a cell with 5 if functions already and I need to add another arguement that if cell A doesn't have the text "Apple", "Banana", "Orange", "Carrot" or "Pear" then say "S", if not then say "".

that possible?

Many thanks
Mike