Payment formula questions

M

Marta

Hi,
I have posted my question before, but I'm still having problems. Here is
the scenario:
B3 = payment amount
Col C = value of account
Col D to Col O = Jan. to Dec.
There can be an ulimited number of accounts.

What I want to do is this: payment comes from value of account 1 until there
is no money left, then the payment switches to account 2, etc. The formula
I'm looking for is to populate the month cells. For example if payment is
$300 and there is $2200 in account 1, then payments for Jan. to Jul and part
of Aug payment should come from account 1, then it should switch to account
2, etc.

The formulea that was suggested doesn't work completely. Here they are:
=MAX(MIN($C$8-(COLUMN(A:A)-1)*$B$3,$B$3),0) fill right
=MAX(MIN($C9-(COLUMN(A:A)-1)*$B$3+SUM($D$8:D8),$B$3-SUM(D$8:D8)),0) fill
right and down

The problem with these is that when an account runs out of money it switches
to the next account regardless if there is money or not.

Did I copy the formula wrong or is there something that can be done to fix
this?
Thanks,
Marta
 
Top