Www.swlearning.com

Enter C12 in the Set Target Cell box. Select the Min option. Enter B10:C10 in By Changing Cells box. Choose Add. Step 4: When Add Constraint dialog box appears: Enter B15:B17 in Cell Reference box. Select >=. Enter D15:D17 in Constraint box. Choose OK. Step 5: When the Solver Parameters dialog box appears: Choose Options. ................
................