Dear All,



I have a problem and try to solve .I am desperately hitting for solution.
Col B and ColI is fixed.
my Total amount in Cell j206 is fixed constraint.
Let it be 80000.00
I want to play only with quantity in colG in such a way that after multiplying each value in ColG with corresponding
value in Cell I then total Amount in j.
After Summing j2:j205 the total should be 80000.(fixed)

For Example if i put 90000.00 in cell J206 then quantity automatic adjusted in Col G.(Range G2:G205).
Moreover, The Quantity in Remove cLADDING, rEMOVE INSULATION, INSTALL INSULATION,INSTALL CLADDING must be same.

Any Solver or technique in this regard is deeply welcome.

Attached file is for ur ref.


Rgds,

Aligahk06

Attached Files

test.zip (97.4 KB, 15 views)