Hi,
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?
Thanks!
