title: Excel IF OR AND Nested Formula
body: <p>I need logic to choose a certain calculation based on two possible criteria.</p>
  <p>The first criteria is:</p>
  <ul>
  <li>If column B = &quot;Partial&quot;</li>
  <li>If columns C and D are greater than 20%</li>
  <li>Then return column E.</li>
  <li>Else If C and D are less than 20 percent then return 1.</li>
  </ul>
  <p>The second criteria is:</p>
  <ul>
  <li>If column C and D are greater than 20%</li>
  <li>Then return column E</li>
  <li>Else return column F.</li>
  </ul>
  <p>So far I have the following, but I return #VALUE!:</p>
  <pre><code>=IF(OR(AND(B2=&quot;Partial&quot;,C2&gt;0.2,D2&gt;0.2)),E2,1),IF(OR(AND(C2&gt;0.2,D2&gt;0.2)),E2,F2)
  </code></pre>