Hi,



I'm currently trying to find a way to return a numeric value from a list of
betweens. For example, the costs relating to transport cost x amount if less
than 100kg, y if between 100 and 200, z if between 200 and 300 and so on. Is
there a way to do this in excel, without doing a very lengthy if formula?



If not, I'm not sure how to go about the IF formula, as it contains too many
values for excel - I have about 20 possible results.