Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way in Excel to produce results for the following problem:
Let's say I have a pipe to be installed that is 120 ft. long. There are three lengths of pipe that I can use 8', 6', and 4'. I want to know ALL of the possibilities for construction. Example: One solution would be (10) 8' pipes (4) 6' pipes, and (4) 4' pipes. I want to know ALL of the solutions. Thanks Chris P.S. I know how to find the optimal solution with the solver (ie. lowest cost) but still need to know all of the possibilities. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How can I print out a list of statistical functions in Excel (I d. | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |