Prev Previous Post   Next Post Next
  #1   Report Post  
ChrisA
 
Posts: n/a
Default Excel Functions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Can I use variables for workheet name references in Excel functions? Amihai Bareket Excel Worksheet Functions 1 February 4th 05 05:11 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
How can I print out a list of statistical functions in Excel (I d. pegberger Excel Worksheet Functions 1 January 5th 05 10:12 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"