Assuming that your table of values for ranges of discounts are in cells
D1:F3 with D having the starting amount, E have the upper amount and F
have the Discount, ie

1 100000 20%
100001 200000 19.5%
etc
etc
etc

Use the following formula:-

vlookup(A1,D1:F3,3,true)

This will return the discount to be used for the value entered in A1


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=500681