Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Needed
Hi,
I want to distribute a certain amount by the following rules: ---Data-------------- ---first distribution------------------ Dept. Amount Received Distribuited Remaining A* $ 100 $ 60 $ 100 $ 60 B* $ 200 $ 10 $ 200 $ 10 C $ 300 $ 90 $ 0 $ 390 D $ 300 $ 140 $ 0 $ 440 $ 900 $ 300 $ 300 $ 900 Percentajes for the distribution: --------Receivers----- Senders A B C D Grand Total A N/A 10% 50% 40% 100% B 30% N/A 20% 50% 100% The problem is that i got to keep distributin (looping) "x" times until Senders (A,B) become zeros or an insignifican amount. Any help will be great apreciated. Thanks, AmK. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Needed | Excel Discussion (Misc queries) | |||
formula needed | Excel Discussion (Misc queries) | |||
Formula Set Up Needed | Charts and Charting in Excel | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions |