Results 1 to 4 of 4

Linking dynamic value in formula

Threaded View

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

    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

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. [SOLVED] 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