title: How to calculate commissions based on the threshold in Excel?
body: <p>I have a threshold limit like below,</p>
  
  <pre><code>5000 - 10000 is 20%
  10000 - 20000 is 25%
  20000 - above is 35%
  </code></pre>
  
  <p>if my input is 40000 then the output should be ( 20% of 10000) + (25% of 20000) + (35% of 10000) .</p>
  
  <p>Could someone help, please?</p>