title: How to examine multiple conditions in multiple cells at the same time in excel
body: <p>How to examine multiple conditions in multiple cells at the same time in excel</p>
  
  <h2>State of art</h2>
  
  <p>In cell A1, I have room number which must be cleaned (e.g. 102, 420, ...)<br>
  In cell B1, I have month name<br>
  In cell C1, I have the floor number<br>
  In cell D1, I want to insert "Yes" or "No" to indicate if the room in that month must be cleaned or not.</p>
  
  <h2>Conditions</h2>
  
  <p>I want to insert a formula in D1 according to the following conditions:</p>
  
  <p>If A1 is "100" <strong>or</strong> "200" <strong>or</strong> "300" <strong>and at the same time</strong><br>
  If B1 is "April" <strong>or</strong> "August" <strong>or</strong> "December"  <strong>and at the same time</strong><br>
  If C1 is "1" <strong>or</strong> "3" <strong>or</strong> "5"  </p>
  
  <p>then insert "Yes", otherwise "No".</p>