I want to test if a value falls between a range of numbers and then give me the resulting value assigned to that range. This is for a shipping tariff. For example:
Weight = 2000 lbs
Weight Range Rates
0 - 1500 lbs = $19
1501 - 2500 lbs = $38
2501 - 3500 lbs = $76
I want to look up the...