not match, Not LIKE problem

[#1]

Hi All,

This is a really small problem. I am trying to filter out these below names and get all other names, hence i have put a <> (not) sign. But still i get all these names. What is the mistake here?

=if( SUBJECT_AREA <> 'Bop_Settlement'

or SUBJECT_AREA <> 'Conf_Dim'

or SUBJECT_AREA <> 'HODS_CTIX_DD'

or SUBJECT_AREA <> 'Reporting'

or SUBJECT_AREA <> 'WAR'

or SUBJECT_AREA <> 'WebTrends' or wildmatch(SUBJECT_AREA,'CODS*')=0,SUBJECT_AREA)

Thanks in advance!

[johnw · Accepted solution]

Use "and" instead of "or".

[#3]

Thanks so much!