Cost of Carriage based on Volumetric Weight

Hello,

I am part way through the creation of a 'simple calculator' which when complete will automatically tell me the cost of a delivery for a box based on it's volumetric weight.

I say part way through as I have come stuck, unable to create a inteligent formula for giving a cost in £ based on the figure in Kg, instead I have come up with the following:

=IF(H30<Q13,S12,IF(H30<Q14,S13))

What I have done is assigned a cost per 1kg, ending up with 1-200 Kg each with a £ associated to it. That is a heck of a long formula if using IF as outlined above.

Probably easier to understand what I am trying to achieve by looking at my attached example.

Maybe it is as hard as it seems, then again no doubt I am over complicating it!

If rather than having 2 columns for weight and 2 columns for cost, you just have 1 for each... you could use a VLOOKUP

=VLOOKUP(H30,$Q$3:$S$203,3,TRUE)

Thank you both, worked a treat. Going to use it for a couple of weeks then maybe try and enhance it (with help from my friends)!

Best

R.