Allocating Intergers based on Relative Percentage

  • Thread starter Thread starter Jim Thomlinson
  • Start date Start date
Interesting but once again it is full of volatile functions and will dim the
lights on the ol' death star.
 
Bob Phillips said:
I thought about round, and came up with
D1: =MAX(ROUND($G$1*C1,0),1)
D2: =MAX(MIN($G$1-SUM($E$1:E1),ROUND($G$1*C2,0)),0)
Click to expand...

I don't believe that works when the number of units is 6, what Jim started
with, or less.

In fact, I believe it does not work for a wide range of numbers.
Considering just the numbers <= 100: 2-6, 16-18, 26, 27, 37-40, 42, 43, 55,
65-67, 79-82, and 88-92.


----- original message -----
 
PS....

By "not work", I mean that it fails to meet Jim's criteria, specifically:
"all units must be allocated. No more and no less".


----- original message -----
 
Back
Top