Hi!
I’m sure someone will find this to be very easy…. I’m needing to retrieve a value from a chart that has ranges. Normally I do a lot of vlookups, and nested if’s, however there has to be an easier, more appropriate way to determining the value when there is a “range” as opposed to a defined value. Below is an example of what I’m trying to do:
I need to refer to the chart and determine what % discount to apply (below is the chart)… so if the bill is $2,500, I’ll need a formula to refer to the cell with the $2,500 in it and look up the low end of the range and the high end of the range and determine which range it falls into, and then select the proper percentage. The percentage I would need in this case is 30.5%. Any help on this one would be great!
Thanks!!
LJM 
$0.01 $1,809.99 0.0%
$1,810.00 $2,069.99 15.0%
$2,070.00 $2,329.99 21.4%
$2,330.00 $2,849.99 30.5%
$2,850.00 $3,369.99 31.4%
$3,370.00 $100,000.00 32.0%
