title: Using IF with OR, AND and Wildcard in same statement
body: <p>I'm trying to create an IF statement that will basically look at one cell which currently has a macros enabling multi-select drop down from a lookup list.</p>
  
  <p>The field the IF statement is based on is a drop down containing the following information:</p>
  
  <pre><code>Android
  iOS
  PC/Mac
  All Devices
  Mobile Devices
  </code></pre>
  
  <p>The user can select one value or multiple values.</p>
  
  <p>The IF statement will be true IF, the field contains <code>All Devices</code> OR <code>Mobile Devices</code> OR <code>Android</code> AND <code>iOS</code> together. It must also be able to check wildcard as you can select multiple items therefore could be <code>Android, PC/Mac, iOS</code> in which case it should be true because both <code>Android</code> and <code>iOS</code> has been selected.</p>
  
  <p>What should be the actual statement as this is the current one I'm using but I know you can't have wildcard string within this statement:</p>
  
  <pre><code>=IF(OR(C7="*-iOS*",C7="*-Android*",C7="Mobile Device",C7="All Delivery Methods",AND(C7="*-iOS*",C7="*-Android*")),"Mobile DTC/ALL","STB (VRP) HD, DEVICE (UVP) HD")
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Edit: If any of the following Scenarios is met and exist in Cell C7, then return the True statement. </p>
  
  <p>Scenario 1: All Delivery Methods
  Scenario 2: Mobile Devices
  Scenario 3: Android AND iOS</p>
  
  <p>Otherwise return the False statement.</p>