Calculate costs

**Adam46** · 09-13-2014, 04:53 AM

Hey all,

This is my first post here, so forgive me if I didn't obey the rules/protocols correctly

In Excel, I'm trying to calculate total shipment costs. I have a sheet with around 180 shipments, each for which the weight (kg) is given. I can then decide to ship the cargo in 3 different containers, which differ in capacity and cost.

\1

For each shipment, I would like to calculate how much it would cost to use each type of container.

If I choose a type of container, the entire shipment would be shipped using that type of container. For instance, a 3220 kg shipment shipped in container type 1 (max. 2000 kg, cost 1500) would mean I need 2 containers, thus having total costs of 3000.

I'm not asking you to solve the whole thing for me, I'm trying to learn here so I don't mind figuring it out myself. Just a little help would be appreciated as I have no clue where to begin...

Thanks in advance

**Richard Buttrey** · 09-13-2014, 04:57 AM

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Please don't upload pictures or show links to pictures. They are rarely much use and we prefer to see requests in context.

**oeldere** · 09-13-2014, 04:59 AM

http://www.excelforum.com/the-water-...-question.html

**sktneer** · 09-13-2014, 08:07 AM

Hi Adam,
Welcome to the Forum.

Images are hard to work with.
But based on the image you uploaded, try this.....

In G2

Please Login or Register  to view this content.

and then copy it across ( to I2) and down as per your need.

In K2

Please Login or Register  to view this content.

and copy down.

Is this what you are trying to achieve?
If not, please upload a sample workbook with enough sample data in it along with the desired output filled manually.