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
Thanks for the reply but my formula doesnt seem to work for the range.. so it will find 100, 500 but wont fine 150...
You need to have the "TRUE" value at the end of the formula to search for an approximate value in your lookup table.
Sorry I have just seen that you had True... at the end!!
Works like a charm thank you! I could have saved a lot of time if I had asked earlier
Did you like this article? Share it with your favourite social network.