Multiple stage multiplication in a single cell.

I have to maintain freight cost according to the shipment weight. Our shipper has different charges for different scale/quantity of shipment. For example, according to the attached picture; Rate for up to 10 Kilo is $ 20 per kilo. For weight more than 10 kilo and up to 20 kilo, Rate will be $ 15 per kilo and so on.

Now, suppose my shipment weight is 28 kilo. My cost will be $ 200 for 10 kg, $ 150 for next 10 kg and $ 80 for the last 8 kg. In total $ 430.

I have to calculate the total cost separately. I wonder if I could devise a formula by which I could put the weight in a single cell and get the freight cost instantly.

Thanks everybody.
Bubai

Yes, you could.
Basically, all you have to do is reasonable use of VLOOKUP
But you given a picture and I am a lazy guy so will not mase spreadsheet for you.
Similar problem (much more complicated approach) solved this morning (have you used "Search" in upper-right corner?) can be seen here: http://www.excelforum.com/excel-new-...or-pallet.html

There you go. I have attached the xl file now.