If(not(Wildmatch...with 2 conditions, like OR

[Anonymous]

=if(not(wildmatch(Site_Id,'*pr*')),Site_Id, 'Ignore'))

The above returns 'Ignore' whenSite_Id contains pr.  I would like to extend it to do that same when Site_Id contains Site_Id mr. 

[swuehl · Accepted solution]

Try

=if(not(wildmatch(Site_Id,'*pr*','*mr*')),Site_Id, 'Ignore'))

[Anonymous]

I thought I had tried that...apparently not.  Thank You!