Do you mean
(1) the percentage of total volume must stay same for each item or
(2) the ranking of each item must remain unchanged?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sige" wrote in message
oups.com...
Hi There,

My Case:

A1:A10 contains Unit volumes for the 10 items
B1:B10 contains Unit price
C1:C10 = A*B
C11 = Total Price
D11 = Target Price

By just changing the Unit volumes I want to reach the Target Price.

My constraint:
Each Item should keep it's relative volume share. Easy enough to
calculate it without Solver but...how do you determine that constraint
with Solver???

Thanks for your insight,
Brgds Sige