I am trying to create an equation that will figure out automatically the correct numbers.
I will have a random number of groups (as many as 20).
Each group will be assigned a value of 2 or 1. I need to divide the groups into percentages that equal 100%. All the groups assigned a 2 need to be 1.5 more than all the groups assigned 1.
Example: If I have 4 groups and 2 are assigned 2 and 2 are assigned 1, I need an output that equals 30%, 30%, 20%, 20%.
Thanks for any help.
I will have a random number of groups (as many as 20).
Each group will be assigned a value of 2 or 1. I need to divide the groups into percentages that equal 100%. All the groups assigned a 2 need to be 1.5 more than all the groups assigned 1.
Example: If I have 4 groups and 2 are assigned 2 and 2 are assigned 1, I need an output that equals 30%, 30%, 20%, 20%.
Thanks for any help.