Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with this problem
Hello, I need a hand with the following problem as I have not used Excel for quite a while. --------There are 4 categories of goods - A,B,C,D --------Each category has 100 goods/supplies that range in price from $4.00 -$26.00(cents are inclusive: ie - one particular item in category A costs $15.41) --------A certain # of goods must be chosen from each category as follows: A - 3 B - 4 C - 3 D - ONLY 1 ITEM IS NEEDED FROM THIS CATEGORY. HERE IS THE TRICKY PART: A buyer must select the exact number of goods required from each category and the total cost of all 11 chosen goods cannot exceed $100.00 nor can it be below $99.00. So is there a way to get excel to do this and display what goods were chosen? I also figure that there will be more than one set of 11 goods that can fit the answer,(maybe 100s of answers) so is there also a way of showing all possible combinations? Thanks in advance to all of you who respond my email is And before you ask. I am not in Algebra class trying to get other people to do my homework. -- stioffan ------------------------------------------------------------------------ stioffan's Profile: http://www.excelforum.com/member.php...o&userid=26070 View this thread: http://www.excelforum.com/showthread...hreadid=394204 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem With Reference Update | Excel Worksheet Functions | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |