+ Reply to Thread
Results 1 to 4 of 4

Linking dynamic value in formula

  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    67

    Linking dynamic value in formula

    Hello all,

    I'm having a little trouble doing what seems to be simple algebra.

    Currently I have a total number of units, and some activities to reduce the number of units that come through. The activities aren't necessarily in any order, but what I'm looking to do, is to allow volume to adjust based on the components of all 3.

    Example, right now my addressable units is 2000, but what I am looking for is for the volume to be dependent on the other reductions. So that when I reduce Volume by 5% using Exercise 1, Exercises 2 and 3 would be based off of the reduced volume of number 1, and vice versa for all 3.

    Then ultimately, I would apply a cost per unit to that to realize a cost savings figure.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,045

    Re: Linking dynamic value in formula

    Not sure exactly what you meant, but put this in C7:

    =B7*($B$1-SUM(C$6:C6))

    then copy into C8.

    Is that what you meant?

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    67

    Re: Linking dynamic value in formula

    Thank you. I think that's correct. What I want to do is link up the final formula in c9 so that it reflects only the values from column b.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,045

    Re: Linking dynamic value in formula

    By directly substituting the formulae in the cells C6:C8, you can arrive at this formula in C9:

    =B6*$B$1+B7*($B$1-B6*$B$1)+B8*($B$1-(B6*$B$1+B7*($B$1-B6*$B$1)))

    and then you don't need the formulae in C6:C8 - you can just multiply this formula by B2 to get the total cost in D9:

    =C9*B2

    so that you can get rid of the formulae in D6:D8 as well.

    Hope this helps.

    Pete

+ 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. Issue with a dynamic cell linking/reference formula
    By raravind82 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-26-2016, 08:42 AM
  2. Dynamic linking of Worksheets
    By Thatguy99 in forum Excel General
    Replies: 1
    Last Post: 06-16-2015, 02:48 AM
  3. [SOLVED] cell linking - dynamic
    By mrd99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2014, 12:39 PM
  4. Linking a dynamic database
    By mfeng in forum Excel General
    Replies: 4
    Last Post: 07-12-2013, 11:26 AM
  5. Linking a dynamic database
    By mfeng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2013, 12:04 PM
  6. dynamic linking
    By Stefi in forum Excel General
    Replies: 2
    Last Post: 03-06-2006, 07:40 AM
  7. Dynamic Linking
    By user33 in forum Excel General
    Replies: 1
    Last Post: 08-03-2005, 04:05 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