Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF scenarios
This is for a home based business.
Need help trying to find a way to get the most usage out of a 2' x 50' piece of material. Keep in mind that the length can be broken up into multiple pieces (ie: 60' = 2 pieces) but the width cannot (the maxium to be used for each piece is a combined total of 2' with nothing left over) here are the different measurements that I have: 1.75' x 55' 1.25' x 45' ..25' x 50' I am looking for a formula that tells the system to take the 1.75' and the ..25' and add only them to get 2' and then take the 55' and 50' and add them to show 105' which would give me a total of 3 pieces of material. Is this possible and if yes, can you please show me the equation? If it needs details please feel free to email me and i will be happy to show you more. Thanks Rdwngr23 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF scenarios
Try this:
http://www.solver.com/solutions/procutstock.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "rdwngr23" wrote in message ... | This is for a home based business. | | Need help trying to find a way to get the most usage out of a 2' x 50' piece | of material. | | Keep in mind that the length can be broken up into multiple pieces (ie: 60' | = 2 pieces) but the width cannot (the maxium to be used for each piece is a | combined total of 2' with nothing left over) | | here are the different measurements that I have: | | 1.75' x 55' | 1.25' x 45' | .25' x 50' | | I am looking for a formula that tells the system to take the 1.75' and the | .25' and add only them to get 2' and then take the 55' and 50' and add them | to show 105' which would give me a total of 3 pieces of material. | | Is this possible and if yes, can you please show me the equation? | | If it needs details please feel free to email me and i will be happy to show | you more. | | Thanks | | Rdwngr23 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scenarios | Excel Discussion (Misc queries) | |||
scenarios | Excel Discussion (Misc queries) | |||
Scenarios | Excel Worksheet Functions | |||
Scenarios | Excel Worksheet Functions | |||
Scenarios | Excel Discussion (Misc queries) |