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 stioffan@yahoo.com

And before you ask. I am not in Algebra class trying to get other people to do my homework.