View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default number to fit the best

number to fit the best?

Hi. You have {50,45,30}, and your solution to 130 is as given {2,0,1}

What if you have multiple solutions...say 180?
{0, 0, 6} or {0, 2, 3} or {0, 4, 0} or {3, 0, 1}

= = = = =
Dana DeLouis

ekkeindoha wrote:
Good day,
Please help. I would like to get a formula for the following.
The boxes can take the folling weight as maximum.
(A) 50 (B) 45 (C) 30
If I give a total of 130 it should give me 2 X A and 1 X C.

Thanks