Nevermind. I figured it out. Thanks anyway.

"Scott" wrote:

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