Results 1 to 6 of 6

generating numbers to equal #

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    hawaii
    Posts
    3

    generating numbers to equal #

    I have a set of numbers.36 32 33 30 27 24 22 20 18 16 14 12 9 8 7 6. I need to know if excel can let me know what the optimum amounts for each of those numbers to get a certin amount. Example.... I need the number 459. It would give me 12 of the 36, and 1 of the 17 to equal 459. I worked it out with the if function but sometimes it doesn't equal the right number, sometimes its to low. Any help would be greatly appriciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generating unique pairs from a set of numbers
    By mistermat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2008, 07:02 AM
  2. Generating combinations from a column of unique numbers
    By mistermat in forum Excel General
    Replies: 1
    Last Post: 08-31-2008, 06:54 AM
  3. Replies: 6
    Last Post: 07-08-2008, 08:25 AM
  4. generate numbers given probability of outcomes
    By jerdjets in forum Excel General
    Replies: 5
    Last Post: 11-15-2007, 07:25 AM
  5. Generating Random Numbers To Play The UK Lottery
    By robertguy in forum Excel General
    Replies: 1
    Last Post: 09-10-2007, 08:46 AM

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