Defining Decision Variables

To define the decision variables, select or enter cells B3:D3 for By Changing on the Solver pane. If you were adding variables that did not appear in contiguous cells, you would use a comma to separate each cell range, i.e. "B3, D3:E3, G3".