title: Excel VBA negative IF condition
body: <p>We have a company macro that cleans data up for us - formatting and arranging data, but as time has gone by our data sets have shifted. Thus, the macro now gives 'false positives' as it were that I want to exclude, but am not sure how.  Reading around the forms, I thought that If Else might work, but I can't seem to get it to work and I wonder if part of it is because things are so similar. </p>
  
  <p>Macro has a roughly 15 lines in a similar fashion to those below</p>
  
  <pre><code>If InStr(1, Cells(i, placementcol), "RES") Then Cells(i, sitecol) = "Resolution"
  If InStr(1, Cells(i, placementcol), "FBK") Then Cells(i, sitecol) = "Facebook"
  If InStr(1, Cells(i, placementcol), "ATH") Then Cells(i, sitecol) = "Authority"
  </code></pre>
  
  <p>The problem is the last one, where words including "ATH" are being picked out and changed to 'Authority' in the clean data set when they shouldn't be. How can I tell the macro to ignore anything in placementcol that starts with "EATH" or other combinations I want to exclude?</p>