title: Excel nested IF, And, Or
body: <p>How do I calculate at nested if/and/or field in excel?</p>
  <p>For a “potluck” I need to calculate who is paying what.</p>
  <p>Got two variables Kids-Menu Yes/No and Wine-Menu Yes/No. Prices for the Kids-Menu, GrownUp Menu and Wine menu are in separate cells.</p>
  <p>How do make the calculation for Total, got the following scenarios:</p>
  <pre><code>Kids-Menu WineMenu
  No        No
  No        Yes
  Yes       No
  Yes       Yes
  </code></pre>
  <p>Cheers
  <img src="https://i.imgur.com/RI9RyoR.jpg" alt="" /></p>