#### snuiverink

##### New Member

- Joined
- Jan 3, 2006

- Messages
- 9

You all have been helpful before so I hope you can help me now again.

Im looking for a way to calculate mutiple rows with a couple of variables. Im trying to calculate the price of each package im going to send per post.

The variables are:

x:2,83 euros

z:1,53 euros

y:0,17 euros

x stands for the standard cost for each shipment

z stands for the price per package.

y stands for the total of kgs per shipment for each package.

The maximum of weight of one package is 31kg. And no more then 4 packages in one shipment. The weight of each package can vary between 3 and 7 kilograms. The maximum numbers of packages is undefined. But maybe for this example we need to set to a 100. Any ideas how I easily could calculate this in excel without having to calculate them one by one.

Looking forward hearing from you

Regards Rik Snuiverink