Weighted Table

[Rjk214]

Hello everyone,

I am looking to create a table where I can add in weight to an already established number. I currently have a base projection and then I have values for each name (High, Low, Average) on another sheet. There are 3 different weighted options where the total value between the 3 would ultimately add up to 1 (So low could be .25, Average .60, High .20)

The table would ultimately look something like this:

TotalTest.xlsx

I am completely unsure on how to do something like this so any help is appreciated! Thank you so much ahead of time

[mikeTRON]

Can you include a proposed solution? Harcoding is fine, I just can't determine what you are trying to do.

[Rjk214]

Can you include a proposed solution? Harcoding is fine, I just can't determine what you are trying to do.

The weighted table allows me to change the projection based upon the certain weights I enter (Up to 1). This table can be changed with different numbers at anytime!

So lets say today I wanted to enter the weights as follows:

Low (.25) Average (.70) High (.05) ** This gives me a total weight of 1 **

When you go to Sheet 2 you will see that there are totals for each (Low, Average, High). The weights entered in the box in Sheet 1 will then calculate the New Projection based upon what is being entered.



Hopefully that makes some sense! I am sorry I really am quite new to this