Tutorial: Sliding scale prices

Soon you we see here a short tutorial video that shows you how to use calculate sliding scale prices. Until then the following example with nested IFs might give you a first hint:

IF(quantity<100, price, IF(quantity<200, price*0.9, IF(quantity<500, price*0.8, 0.7)))

This formula applies price discounts of 10%, 20%, 30% for quantities higher or equal than 100, 200 and 500 respectively.