Sliding Scale/Thresholds

  • Hello,


    I have a single figure and as the figure increases and moves through thresholds the pay changes. e.g.


    Number of sales payable = 15.66
    Level 1: 1-10 pays 100 for each that falls in this threshold
    Level 2:11-15 pays 150 for each that falls in this threshold
    Level 3: 16-20 pays 200 for each that falls in this threshold
    Level 4: 21+ pays 250 for all above this


    I want to work the amount payable with a formula.


    It should be $1849


    Is there a formula that can calcualte this without me manually figuring out how many in each threshold.


    Thank-you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!