Excel formula that will forward the left over amount to the next column

[MExcel99]

Hello,
Please Help I would like to have it so that when I make a payment, Nothing Gets paid until column B is paid in full

When column B is paid in full, I would like to have the left over amount go to column C, but as I pay Column C

50% goes to Column C, 10% goes to Column D and 20% goes to Column E and F

but once column C is paid in full

Column D gets 10% and Column E & F get 45% each until balance is paid in full

the only forumla I have right now for Mortgage 1 is =IF(B3<=-1,(B3+A4),"PAID")

and for mortgage 2 I have =IF(AND(B3>=1,C3<=0),A4*50%+C3,C3)

Please Help, and Thank You in Advance

attached is a picture
EXCEL.jpg

again, Thank You in advance for any replies

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.