I'm trying to set up a formula on an order sheet. What I need is variable pricing, giving discounts when more than one item is purchased. To complicate things they are able to mix and match from 2 categories. I can't figure out how to do that. 
For example, if they buy 1 item it's $25, 2 items are $40, 3 items are $50.