Thread: Formula Needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AshMorK AshMorK is offline
external usenet poster
 
Posts: 24
Default 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.