Excel - volume discounts

[Cath]

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

[Krono9]

Adapt as required:

[Cath]

Thanks for the reply but my formula doesnt seem to work for the range.. so it will find 100, 500 but wont fine 150...

[Krono9]

You need to have the "TRUE" value at the end of the formula to search for an approximate value in your lookup table.

[Cath]

Sorry I have just seen that you had True... at the end!!

[Cath]

Works like a charm thank you! I could have saved a lot of time if I had asked earlier