How can I make changes to percentages so that the other percentages automatically re-calculate in a way that does not exceed 100%?
Budget: $2 – $3 USD
How can I make changes to percentages so that the other percentages automatically re-calculate in a way that does not exceed 100%?
This is the sheet that is editable by anyone and you can create a separate working tab for yourself if needed.
https://docs.google.com/spreadsheets/d/1CQ0XOANFK7nfSvGAewJZ40xAQgdXyT71Do9hHLs_lig/edit#gid=1657609987
Here is a screencast with audio for further clarification (URL changed).
https://www.screencast.com/t/1d2oQlEw
This is the sheet that is editable by anyone and you can create a separate working tab for yourself if needed.
https://docs.google.com/spreadsheets/d/1CQ0XOANFK7nfSvGAewJZ40xAQgdXyT71Do9hHLs_lig/edit#gid=1657609987
Here is a screencast with audio for further clarification (URL changed).
https://www.screencast.com/t/1d2oQlEw
Related categories:
Google Spreadsheets