+ Reply to Thread
Results 1 to 3 of 3

Sum of and multiples two values should give me the nearest target value.

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Sum of and multiples two values should give me the nearest target value.

    For Example:-

    There are two values 1.5 and 2

    Using these two combination with n number of multiples it should be nearest to 8,8

    Like

    (2*2)+(1.5*3)=8.5
    So we should use 2 times 2 and 3 times 1.5 to reach 8.5 which is neast, it should be more than 8.8.

    If the target values is 7.7

    (2*3)+(1.5*1)=7.5

    How can we do this in excel and how do we achieve with nearest combination.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Sum of and multiples two values should give me the nearest target value.

    First, write the algebraic equation on paper, then transfer into Excel. I think the main part of your question is about algebra, not about Excel. Get the equation you're looking for, then we can help transfer it into Excel if you need.
    <--- If you like the answer, press *.

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Sum of and multiples two values should give me the nearest target value.

    Thanks for the answer, but we wanted the excel to give the result, there is a calulation which gives availability of the space, we need to fill that with 1,5 and 2 mm thickness layers. is it possible that there is a equation or function in the excel which will give me this solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List multiples values that each correlate with a unique value.
    By marinemonk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-25-2013, 01:44 PM
  2. [SOLVED] Counting Multiples Values in one cell
    By ROB40160 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2012, 09:28 AM
  3. Convert list of unique values into multiples quickly
    By lukiebabie in forum Excel General
    Replies: 4
    Last Post: 05-04-2012, 10:57 AM
  4. Replies: 1
    Last Post: 07-29-2010, 12:22 PM
  5. combine multiples values that equal known total?
    By mn1171 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2009, 05:40 PM

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