01-26-2010, 12:25 PM
|
Administrator
|
|
Join Date: Oct 2009
Posts: 5,409
|
|
- Next we need to tell Excel that we must have a minimum of four small cars.
- Click on the Add ****on.
- In the Cell Reference text box either enter the reference $C$4
OR use the mouse to click on the cell C4 and the cell reference will be entered automatically.
- Select >= from the center part of the dialog box.
- In the Constraint box, enter the value 4.The dialog box will be as illustrated below.
-
- Next we need to tell Excel that we must have a minimum of three medium sized cars.
- Click on the Add ****on.
- In the Cell Reference text box either enter the reference $C$5
OR use the mouse to click on the cell C5 and the cell reference will be entered automatically.
- Select >= from the center part of the dialog box.
- In the Constraint box, enter the value 3. The dialog will be as illustrated below.
-
|