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