title: Conditional Excel Formula including "Or"
body: <p>How can I properly include an <code>OR</code> function in a conditional Excel formula? </p>
  
  <p>I have two formulas that I would like to combine with an <code>OR</code> function as follows:</p>
  
  <pre><code>=IF(AI6="Left Urn Selected", BB6)
  
  =IF(AI6="Right Urn Selected", BC6)
  </code></pre>
  
  <p>..so that if the first condition is true, the value in <code>BB6</code> will be shown. And if the second condition is true, the value of or <code>BC6</code> will be shown. </p>
  
  <p>In context...</p>
  
  <p><img src="https://i.stack.imgur.com/HJhac.png" alt="Image 1"></p>
  
  <p><img src="https://i.stack.imgur.com/RJaz2.png" alt="Image 2"></p>
  
  <p>Thanks for any advice you can provide.</p>