Excel

custom filter

[Acternaweb]

Please help, I am using excel, and able to custom a filter but with only two criteria. I am trying to have at least three criteria:

for example:

contains "word"
or
contains "word 2"
and
does not contain "word 3"

Any ideas?

[davidpbrown]

=IF(EXACT("word 3",A1), "is 'word 3'", IF(EXACT("word",A1), "OK", IF(EXACT("word 2",A1), "OK", "NOT 'word 3' but also not either word or 'word 2'")))

returns OK if cell A1 NOT 'word 3' AND (either word or 'word 2').