+ Reply to Thread
Results 1 to 2 of 2

Value * Multiplier > SUM of all Values - but I only know the Multiplier

  1. #1
    Registered User
    Join Date
    01-31-2020
    Location
    Austria
    MS-Off Ver
    Excel 365
    Posts
    1

    Value * Multiplier > SUM of all Values - but I only know the Multiplier

    Hello,

    I only have the logic for this and I am not sure if you kind people can help me somehow make this into functional formulas.

    I hope the picture below better explains it and that this is the right place to post a question like this.

    2020-01-31 11_37_43-calculations.xlsx - Saved.png

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,303

    Re: Value * Multiplier > SUM of all Values - but I only know the Multiplier

    are you saying you want to input the multiplier AND have it change if it is higher than the value in the sum? Because that would require VBA.
    here is how I would handle it. you enter your values in the value calculated rows, you sum those values, if you want a multiplier you can enter it in the multiplier column and then have the value * multiplier rows, but I'd add a section of what the multiplier should be which would be the 493/300 and 493/130 etc. That would return the value that the multiplier should be. See attached workbook.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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] VBA Macro FUNCTION To Sum Up Values of multiplier of muti-Columns
    By tungtran.ftu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2015, 12:53 AM
  2. [SOLVED] Help - Need to check values in order to assign correct commission multiplier
    By sx200n in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2014, 11:07 AM
  3. using Countif but also taking into account multiplier values
    By rezarf26 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2014, 03:01 PM
  4. Can i add a multiplier in a Sumif?
    By HUNTXTRM in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 02-26-2014, 08:17 PM
  5. Excel 2007 : IF multiplier
    By Martin Chamberlin in forum Excel General
    Replies: 7
    Last Post: 06-05-2011, 03:53 PM
  6. Locate multiplier
    By Tedebear in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-09-2011, 12:30 PM
  7. Data validation for multiplier values
    By Egan in forum Excel General
    Replies: 2
    Last Post: 05-24-2010, 02:35 PM

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