Results 1 to 10 of 10

Making sure variable is an integer?

Threaded View

  1. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    If I did it right, I get 215 tables and 136 chairs:

           --A--- -B-- -C-- -D-- ---E--- -F- -------------G-------------- --H-- ----I-----
      13   Profit wood prod time Fitting box           Formula            Value Constraint
      14   tables 215   70   20    72     1              =20*x + 12.5 * y  6000 <= 6000   
      15   chairs 136   30  12.5   18     1                        =x + y   351 <= 400    
      16          > 0  > 0                               =72 * x + 18 * y 17928 <= 18000  
      17                                     =SUMPRODUCT(B14:B15,D14:D15)  6000 maximize
    Last edited by shg; 02-03-2008 at 03:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1