| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number to fit the best
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number to fit the best
Hi,
If you have "50" in A1, "45" in B1, "30" in C1 and your target ("130") in A3 then the following works but it's a bit horrible: =INT(A3/A1) & "*A+" & INT((A3-INT(A3/A1)*A1)/B1) & "*B+" & INT((A3-INT(A3/A1)*A1-(INT((A3-INT(A3/A1)*A3)/B1)))/C1) & "*C" "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number to fit the best
I haven't used it too much, but I think the Scenario tool will give you just
the answer you're looking for... "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number to fit the best
Plse explain how to sort out with Scenario tool.
Thx "JEV" wrote: I haven't used it too much, but I think the Scenario tool will give you just the answer you're looking for... "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
| How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Hybrid Mode
