+ Reply to Thread
Results 1 to 2 of 2

Probably easy, but I don't get it

  1. #1
    Registered User
    Join Date
    01-17-2007
    Posts
    9

    Probably easy, but I don't get it

    Hi, I'm trying to set up an excel sheet to do some solver on.

    Here is the problem:
    I got a column where indicator values will be set in by solver eventually
    If value is 1 the neighbouring cell will show the number on the left like thus:

    07 | 0 |
    10 | 1 | 10
    14 | 0 |
    17 | 1 | 17
    14 | 0 |
    17 | 0 |
    21 | 1 | 21

    This is not precisely what I want. I want it to show the difference between the given intervals ofnumbers like thus:

    07 | 0 |
    10 | 1 | 10
    14 | 0 |
    17 | 1 | 7
    14 | 0 |
    17 | 0 |
    21 | 1 | 4

    The solver will try to choose the indicators to set to 1 eventually, based on other criteria as well, point is that the numbers on the right have to be between 3 and 9

    HOW DO I DO THIS??

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Probably easy, but I don't get it

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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