Hi all,

I'm trying to make a formula that says "if cell A contains cell B AND does not contain cells C D or E, then cell A, else 1". My first effort only had one extra criteria:

=IF((ISERROR(SEARCH(F$1,'Com. Development FN'!$M8))=TRUE)+(ISERROR(SEARCH(F$694,'Com. Development FN'!$M8))=FALSE),1,'Com. Development FN'!$M8)

And it works like a charm. When I attempted to expand my criteria however (i.e. "does not contain cells C D or E", as opposed to "does not contain cell C"), all of it sudden it fails to work probably and always returns a value of "1":

=IF((ISERROR(SEARCH(F$1,'Com. Development FN'!$M2))=TRUE)+(ISERROR(SEARCH(F$694,'Com. Development FN'!$M2))=FALSE)+(ISERROR(SEARCH(F$695,'Com. Development FN'!$M2))=FALSE)+(ISERROR(SEARCH(F$696,'Com. Development FN'!$M2))=FALSE),1,'Com. Development FN'!$M2)

Anyone have any ideas what the issue here might be? I'm afraid I can't attach the spreadssheet itself as it contains confidential info, but I could potentially take screenshots of certain bits if that would help. Thanks very much for taking the time read!