Hi All
Any idea what formula I would use if wanting to calculate a percentage volume discount...
E.g if cell A1 shows total of items -
100 - 500 items 5% discount
501 - 700 7.5% discount
701 - 900 10% discount
Many thanks
Catherine
Hi All
Any idea what formula I would use if wanting to calculate a percentage volume discount...
E.g if cell A1 shows total of items -
100 - 500 items 5% discount
501 - 700 7.5% discount
701 - 900 10% discount
Many thanks
Catherine
Did you like this article? Share it with your favourite social network.