LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing large number of non contiguous cells evenly distributed James D Excel Worksheet Functions 5 September 7th 08 04:53 PM
Spreading 1 large number evenly into several cells Dos Equis Excel Worksheet Functions 0 October 4th 06 05:50 PM
requesting formula for distributing a number Julie Excel Discussion (Misc queries) 5 August 21st 06 09:40 PM
Distributing a Cell Value MLCole Excel Worksheet Functions 5 March 7th 06 05:23 PM
distributing numbers Neil Excel Discussion (Misc queries) 1 April 15th 05 06:41 PM


All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"