Hello, everyone,
I have a list of 12 beverages with checkboxes next to them to pick which ones I want to include in the calculation.
In the next column, I have an equal percentage of all selected beverages (if 5 are selected, the formula divides 100% by 5, assigning each of them the value of 20%, as an example.)
Column E lists arbitral percentages based on the beverages' popularity—the percentage of a given beverage people have in relation to others offered.
The problem: how do I make the numbers in column F (expected usage per beverage) reflect the percentage bias from column E? The idea is that those percentages always equal 100% but change proportionally (in contrast to column C, where they check equally).
Here's the link to the quick gif showing it CleanShot 2020-01-11 at 16.34.45.gif
I'd appreciate any help a lot!
I have a list of 12 beverages with checkboxes next to them to pick which ones I want to include in the calculation.
In the next column, I have an equal percentage of all selected beverages (if 5 are selected, the formula divides 100% by 5, assigning each of them the value of 20%, as an example.)
Column E lists arbitral percentages based on the beverages' popularity—the percentage of a given beverage people have in relation to others offered.
The problem: how do I make the numbers in column F (expected usage per beverage) reflect the percentage bias from column E? The idea is that those percentages always equal 100% but change proportionally (in contrast to column C, where they check equally).
Here's the link to the quick gif showing it CleanShot 2020-01-11 at 16.34.45.gif
I'd appreciate any help a lot!