Excel: Formula help

hi, i have some weights(kg) in cell A2. so i have two type of packages to fill that weights.one package is 1.5kg & other one is 1 kg. i want use that two pckage to fill that A2 cell weights with less different. but there are two conditions. 01. always 0.5 kg need to add to A2 cell weights. 02. for weight adjusting u can use only maximum 2 of 1 kg packages.so as a example to fill 13.8 kg result should like bellow..(my excel sheet also data appearing like bellow table) =13.8+0.5 = 14.3 so i have to use 9,1.5 pks & 1, 1 kg pks. result will be - 14.5 ( that mean only different 0.2kg with actual requirement) if i use 10 of 1.5 kg, then result is =15 ,that mean i have used more than 0.7kg. best option is first one.

1.5 kg 9
1 kg 1
so i don't no this is can manage with excel formula or not. so pls help me. thanks a lot...

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of December 10, 2013.

For more resources for Microsoft Excel