Can't be done without some relation applying to ranges...
1 - 999 : x
1000 - 1999: x-1
2000 - 2999: x-2
Hi, any help with this would be hugely appreciated. I'll try and make my question as simple as possible.
I have 49,500 apples. The total cost of these apples is £12,330. I want to sell different quantities of these apples to 22 different people, some people will buy 1,000 apples, others will buy larger quantities, 6,000 and 17,000 for example.
Obviously the more they buy, the cheaper it'll become, but how do I work this out? So that the person buying 17,000 isn't paying the same amount per thousand as the person buying 1,000?
Thanks a lot for any help!!