title: Excel Logic and If Statements
body: <p>I am trying to do write a nested if statement that does the following:</p>
  
  <p>IF C19 = No, C20 = No, and C22 = Yes then C30 = No</p>
  
  <p>else</p>
  
  <p>IF C19 = Yes or C20 = Yes and C22 = Yes then C30 = Yes </p>
  
  <p>So far I have the following (Non-working) code:</p>
  
  <pre><code>=IF(OR(AND(C19="No",C20="No",C22="Yes"), C22="Yes","Yes","No"))
  </code></pre>
  
  <p>Any Ideas?</p>
  
  <p>Thanks.</p>