I want to be able to provide a different percentage discount based on the quantity purchased. The percentage should be based on a range, so for example:
- QTY > 0 && <= 5, discount = 5%
- QTY > 5 && <= 10, discount = 10%
- QTY > 10 && <= 15, discount = 15%
What would be the best way to achieve this in Google Sheets?