View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rvaughnp rvaughnp is offline
external usenet poster
 
Posts: 4
Default Distributing a number evenly over several set priority's.

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