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