Hi,
I am trying to use the Solver add-in and am having trouble with it
My spreadsheet is as follows:
InvNum InvAmt Flag AmtDue
1 100 1 =B2*C2
2 150 1 =B3*C3
<snip rows
50 Total 0 =SUM(D2:D49)

I've set solver up as follows:
Set Target Cell = $D$50
Equal to Value of 844.65
Subject to constraints:
$C$2:$C$49 <= 1
$C$2:$C$49 = integer
$C$2:$C$49 = 0

I want Solver to find that combination of invoices that would give me a
total of the target value.
The logic is that the flag would either be 0 or 1.

However, Solver does not recognize the second constraint: $C$2:$C$49 =
integer, and iterates all possible values between 0 and 1.
What am I doing wrong?

I recall doing this before, and I can't see where I am wrong.

Thanks in advance for any assistance.

Regards
Habib



--
Habib Salim
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 10