# Multiple stage multiplication in a single cell.

1. ## 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

2. ## Re: Multiple stage multiplication in a single cell.

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

3. ## Re: Multiple stage multiplication in a single cell.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1