My data are like This
<tbody>
</tbody>
As a matter of math its easy the 30 % remaining will be allocated as 15% and 15 % ...
What i need is when i change Col1 value ,factor2 and factor3 auto-renormalize eg.(15-15) so that sum=100 for all 3 columns
and the same happens when i change Col2 value , factor1 and factor3 changes accordingly
same for col 3. factor 1,2 change
for all of the above scenarios ( Scenario 1 = direct manual input so total = 100 )
Scenario 2 ( 1 manual and 2 auto calculated )
Scenarios 3 ( 2 manual and 1 auto calculated)
I need a unified Column Formula or a VB code to do the above Scenarios depending if the offset cell (Col1,2,3) empty or not
TotalFeed | Col1 | Col2 | Col3 | Factor1 | Factor2 | Factor3 |
100 (sc-1) | 50 | 25 | 25 | =50/100 | =25/100 | =25/100 |
100 (sc 2) | 70 | =70/100 | ? | ? | ||
100 (sc-3) | 70 | 15 | =70/100 | =15/100 | ? |
<tbody>
</tbody>
As a matter of math its easy the 30 % remaining will be allocated as 15% and 15 % ...
What i need is when i change Col1 value ,factor2 and factor3 auto-renormalize eg.(15-15) so that sum=100 for all 3 columns
and the same happens when i change Col2 value , factor1 and factor3 changes accordingly
same for col 3. factor 1,2 change
for all of the above scenarios ( Scenario 1 = direct manual input so total = 100 )
Scenario 2 ( 1 manual and 2 auto calculated )
Scenarios 3 ( 2 manual and 1 auto calculated)
I need a unified Column Formula or a VB code to do the above Scenarios depending if the offset cell (Col1,2,3) empty or not