View Single Post
  #6  
Old 01-26-2010, 12:25 PM
seema seema is offline
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.

Reply With Quote