# Linking dynamic value in formula

1. ## 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!

2. ## 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. ## 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. ## 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

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

#### 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