CHAPTER 2

Steps in Using Excel Solver: Step 1: Select the Tools pull-down menu. Step 2: Select the Solver option. Step 3: When the Solver Parameters dialog box appears: Enter C12 in the Set Target Cell box. Select the Equal To: Min option. Enter B10:C10 in the By Changing Cells box. Select Add. Step 4: When the Add Constraint dialog box appears: ................
................