Is there any possibility to do an interval match directly in the sheet (as a Master Element, for example), in combination with a Variable Input?
I have a table with Volume Based Discounts. Something similar to this:
Min QTY
Max QTY
Discount
0
100
0%
101
500
5%
501
1.000
10%
1.001
10.000.000.000
15%
In a sheet I have a variable input, where the user can input some quantities. I would like a master element which calculates the discount based on the new input quantities. Is that possible?
