Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1
A[100] B[priority1] (30) C[priority2] (25) D[priority3] (40) (100) is a balance. I want the balance to be distributed amongst the priority's 1-3. (A[100]) is a growing number that starts at [0]. "B[priority1] (30)" starts to add its percentage of (A[n]) as soon as "A" reaches [1]; then "B" stops when its total "30" is met. "C[priority2] (25)" does not start its percentage calculations until "B[priority1] (30)" has been satified at (30). Then any addition to (A[n]) ie "A[31]" is added to "C[priority2] (25)" and so on. I would appreciate any help. Rvaughnp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing large number of non contiguous cells evenly distributed | Excel Worksheet Functions | |||
Spreading 1 large number evenly into several cells | Excel Worksheet Functions | |||
requesting formula for distributing a number | Excel Discussion (Misc queries) | |||
Distributing a Cell Value | Excel Worksheet Functions | |||
distributing numbers | Excel Discussion (Misc queries) |