Helllo!
Please see the attached spreadsheet, it describes what I'm talking about better than I can here.
I have a 5 cells that are percents that add up to 100%. I want to be able to adjust one cell and have the other adjust so that the total is 100%. But what I can't figure out is: I want there to be logic of which cell adjusts and by how much. Each cell will have their own logic for how the % is distributed to the other 5 cells. Is this possible somehow?
Ideally (end goal) I would have sliders for each cell that automatically adjusts all other cells based on that logic so that the total is always equal to 100%.
Thanks!
Bookmarks