Results 1 to 4 of 4

Finding what multiples to a target number, multiple cells.

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    1

    Finding what multiples to a target number, multiple cells.

    Hello- I am trying to figure out if there is a function in excel, to determine what numbers 'x' must be to get a sum total of $21,843.00..

    Missing # Multiplier SUM
    A X $180.00 $- (X*180)
    B X $180.00 $- (X*180)
    C X $92.00 $- (X*92)
    D X $92.00 $- (X*92)
    E X $92.00 $- (X*92)

    $21,843.00 (Total of all sums aka target number)


    I can use excel and type in numbers individually until it sums up to correct number, but that takes a long time. I am looking for a shortcut. Does anyone have an idea?
    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. Finding a Target Number
    By PaulB1980 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2017, 12:19 PM
  2. [SOLVED] Conditional Formatting For Cells with Multiples of a Certain Number
    By JAMES456 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 12:59 PM
  3. Sum of and multiples two values should give me the nearest target value.
    By Roopa Rani in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 08:25 AM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. [SOLVED] increasing a cells number by multiples
    By Earthfury in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-09-2012, 02:50 AM
  6. Finding a number in multiple cells with each of its own range
    By mmm213 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-14-2009, 06:46 PM
  7. [SOLVED] can 1 excel's DROP target change MULTIPLE cells?
    By Huy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2006, 04:05 AM

Tags for this Thread

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