Help with Solver!!!

[geanders]

Hi, I'm trying to make a Solver function to MAXIMIZE the amount of total return on a stock portfolio. It needs to satisfy the following constraints:

Condition 1: Additional shares can be bought only in “Health Care” Companies in the portfolio.
Condition 2: The maximum number of additional shares in each “Health Care” company in the
portfolio that can be bought is 250
Condition 3: Fractional shares cannot be bought.
Condition 4: The total additional money available (The sum of money paid for additional shares in
Health Care companies) for investment is $60,000.

I've set this up in Solver like this:

$D$4:$D$36 = $Y$6 ((D4:D36 is the specification of the industry for each stock)) ((Y6 = Health Care))

$T$4:$T$36 <= $Y$7 ((T4:T36 is the blank range of cells I've set up for the additional shares to be purchased)) ((Y7 = "250))

$T$4:$T$36 = integer

$T$4:$T$36 >= 0

$X$38 = 60000 (X38 is the total sum of 60,000 that I can spend to purchase additional shares)


I keep getting the same error that says "Variable bounds conflict in Binary or AllDifferent Constraint"

PLEASE HELP!!!!!!!!!

[FDibbins]

Do not post duplicate threads