I am trying to create a variable quantity calculator in excel 2007.
I have 20 items.
Each item has a different weight ex. 1.36kg or 2.70kg etc. and a specified order quantity ex. 3 x 1.36kg, 1 x 2.70kg etc.
My total weight for all 20 items cannot exceed a set value (ex. 50kg).
If I zero the...