Spreadsheet: 723148d1615542932-multiple-criteria-search-for-discount-example
Sheet: Commitment Discounts

 | Year | Partner | Net from | Net til | HELP | Cash Rabatt
 | 2020 | Customer A | 0 | 100000 |  | 0.2
 | 2020 | Customer A | 100001 | 150000 |  | 0.3
 | 2020 | Customer A | 150001 | 300000 |  | 0.4
 | 2020 | Customer A | 300001 | 500000 |  | 0.5
 | 2020 | Customer A | 500001 | 600000 |  | 0.55
 | 2020 | Customer A | 600001 | 700000 |  | 0.56
 | 2020 | Customer A | 700001 | 800000 |  | 0.57
 | 2020 | Customer A | 800001 | 900000 |  | 0.58
 | 2020 | Customer A | 900001 | 1000000 |  | 0.59
 | 2020 | Customer A | 1000000 | 100000000 |  | 0.6
 | 2021 | Customer A | 0 | 100000 |  | 0.2
 | 2021 | Customer A | 100001 | 150000 |  | 0.3
 | 2021 | Customer A | 150001 | 300000 |  | 0.4
 | 2021 | Customer A | 300001 | 500000 |  | 0.5
 | 2021 | Customer A | 500001 | 600000 |  | 0.565
 | 2021 | Customer A | 600001 | 700000 |  | 0.575
 | 2021 | Customer A | 700001 | 800000 |  | 0.585
 | 2021 | Customer A | 800001 | 900000 |  | 0.595
 | 2021 | Customer A | 900001 | 1000000 |  | 0.6
 | 2021 | Customer A | 1000000 | 100000000 |  | 0.6
 | 2020 | Customer B |  | 25000 |  | 0.025
 | 2020 | Customer B |  | 50000 |  | 0.03
 | 2020 | Customer B |  | 100000 |  | 0.04
 | 2020 | Customer B |  | 150000 |  | 0.05
 | 2020 | Customer B |  | 200000 |  | 0.06
 | 2020 | Customer B |  | 250000 |  | 0.07
 | 2020 | Customer B |  | 300000 |  | 0.08
 | 2020 | Customer B |  | 400000 |  | 0.09
 | 2020 | Customer B |  | 450000 |  | 0.1
 | 2020 | Customer B |  | 500000 |  | 0.11
 | 2020 | Customer B |  | 550000 |  | 0.12
 | 2020 | Customer B |  | 600000 |  | 0.13
 | 2020 | Customer B |  | 700000 |  | 0.135
 | 2020 | Customer B |  | 800000 |  | 0.14
 | 2020 | Customer B |  | 900000 |  | 0.15
 | 2020 | Customer B |  | 1000000 |  | 0.17
 | 2020 | Customer B |  | 1250000 |  | 0.18
 | 2020 | Customer B |  | 1500000 |  | 0.19
 | 2020 | Customer B |  | 1600000 |  | 0.19
 | 2020 | Customer B |  | 2000000 |  | 0.2
 | 2021 | Customer B |  | 25000 |  | 0.05
 | 2021 | Customer B |  | 50000 |  | 0.06
 | 2021 | Customer B |  | 100000 |  | 0.07
 | 2021 | Customer B |  | 150000 |  | 0.09
 | 2021 | Customer B |  | 200000 |  | 0.11
 | 2021 | Customer B |  | 250000 |  | 0.13
 | 2021 | Customer B |  | 300000 |  | 0.14
 | 2021 | Customer B |  | 400000 |  | 0.15
 | 2021 | Customer B |  | 450000 |  | 0.17
 | 2021 | Customer B |  | 500000 |  | 0.2
 | 2021 | Customer B |  | 550000 |  | 0.22
 | 2021 | Customer B |  | 600000 |  | 0.24
 | 2021 | Customer B |  | 700000 |  | 0.255
 | 2021 | Customer B |  | 800000 |  | 0.265
 | 2021 | Customer B |  | 900000 |  | 0.275
 | 2021 | Customer B |  | 1000000 |  | 0.29
 | 2021 | Customer B |  | 1250000 |  | 0.3
 | 2021 | Customer B |  | 1500000 |  | 0.305
 | 2021 | Customer B |  | 1600000 |  | 0.31
 | 2021 | Customer B |  | 2000000 |  | 0.32
 | 2021 | Customer C |  | 50000 |  | 0.3
 | 2021 | Customer C |  | 75000 |  | 0.4
 | 2021 | Customer C |  | 100000 |  | 0.55
 | 2021 | Customer C |  | 125000 |  | 0.6
 | 2021 | Customer C |  | 150000 |  | 0.65
 | 2021 | Customer C |  | 200000 |  | 0.67
 | 2021 | Customer C |  | 250000 |  | 0.69
 | 2021 | Customer C |  | 100000000 |  | 0.7