calculating discount 15 tiers

Hi all,

any help much appreciated, i am a long time reader but now registered in th hope you guys can help me

i have three columns A=minimum purchase B=maximum purchase and C=discount offered
by 15 rows of tiers of purchase volumes and discounts offered.
i would like to be able to enter a value (say 1500 units in a cell) and excel come back with the discount based on the purchase of this number of units, i.e 12.5% as below

for example

0-1250 will be 10%
1251-2500 will be 12.5%
and so on until we get to about 40% in 2.5% increments, i have tried if statements etc but it seems too complex,

please can someone help me out, i'd be so grateful. thanks

Bamboozle

With the number you want to look up in E1, try

Please Login or Register  to view this content.