S
Scott
I am trying to create a reference sheet to calculate a series of percentage
breakdown totals.
For example, given a total of 5 divisions, I want to calculate 5
percentages, IN INCREMENTAL ORDER, that totals up to 100%.
Now the number of divisions will be a set number, and all divisions will
always add up to 100%.
For example:
5 Divisions = 45%, 25%, 15%, 10%, 5% (maybe not those exact numbers, but
something comparable.)
Or for 3 divisions = 50%, 30%, 20%
Any idea on how to accomplish this?
Thanks
breakdown totals.
For example, given a total of 5 divisions, I want to calculate 5
percentages, IN INCREMENTAL ORDER, that totals up to 100%.
Now the number of divisions will be a set number, and all divisions will
always add up to 100%.
For example:
5 Divisions = 45%, 25%, 15%, 10%, 5% (maybe not those exact numbers, but
something comparable.)
Or for 3 divisions = 50%, 30%, 20%
Any idea on how to accomplish this?
Thanks