Nested IF functions with Search statements

Hey all,

I have 4 possible entries for a cell per row depending on a filename in column A. I wanted to use an IF statement with SEARCH and wildcards:

IF(SEARCH("*x*",A1),"Text to return to field if true", IF(SEARCH...etc.

If I end the statement with a value_if_true field and a value_if_false field, the search works and the cell is populated with the text I want. But if I add another IF statement as my value_if_false field, Excel cannot compute even the first search. Any ideas on this?

thanks

S