title: multiple condition & multiple solution in excel
body: <p>Please help if possible.</p>
  
  <p>I want to create a dashboard in excel, where I want to calculate the total sales of the agents in my shift. But the problem is that I want to calculate multiple agent's sale score in a single case as well.</p>
  
  <p>Conditions:</p>
  
  <ul>
  <li><p>If in a single sale, there are 3 agents, the sale would be divided among the three with the 3rd person getting 50% of the sale amount and the 1st and the 2nd person both getting 25%.</p></li>
  <li><p>If in a single sale, there are 2 agents, the sale would be divided among them equally.</p></li>
  <li><p>If a single agent cracks the sale, the amount would belong to him alone.</p></li>
  </ul>
  
  <p>Now how would I put a formula where these things are calculated automatically?</p>
  
  <p>e.g.: </p>
  
  <pre><code>Agent 1     Agent 2     Agent 3    Sale Amount 
  Adam                                $100 
  Jack         Adam                   $100 
  Nick         Vince      Adam        $100 
  Vince                               $100 
  </code></pre>
  
  <p>According to this, the amount would be as such: </p>
  
  <pre><code>Adam: - $100 + $50 + $50 = $200
  Jack: - $50 = $50
  Nick: - $25 = $25
  Vince: - $25 + $100 = $125
  </code></pre>
  
  <p>This is the kind of result I want but want to get it done automatically as soon as the sale is entered. Anyone know how to achieve it through formula?</p>
  
  <p>Thanks in Advance!</p>