How to deduct from a cell until 0 then deduct from next cell?

[itzzjason]

Hi. I'm trying to create a spreadsheet to help keep track of bills.

I'd like the spreadsheet to calculate how much money I'll have left after paying bills per month.

Example:

[TABLE="class: grid, width: 1000, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Checking account #1 balance[/TD]
[TD]$10000.00[/TD]
[TD][/TD]
[TD]Water bill[/TD]
[TD]$100.00[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Minimum balance[/TD]
[TD]$1500.00[/TD]
[TD][/TD]
[TD]Gas bill[/TD]
[TD]$50.00[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Usable Balance[/TD]
[TD]$8500.00[/TD]
[TD][/TD]
[TD]Electric bill[/TD]
[TD]$75.00[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Remaining balance[/TD]
[TD][/TD]
[TD][/TD]
[TD]Car payment[/TD]
[TD]$300.00[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Checking account #2 balance[/TD]
[TD]$5000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Min. balance[/TD]
[TD]$100.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Usable balance[/TD]
[TD]$4900.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Remaining balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Overall remaining balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to deduct the bills' amount (column E) from the first bank account until it reaches $0.00 (cell B3) then deduct any remaining bills from the next bank account (cell B8).

What formulas can I input into cells B4 and B9?

 

[mikerickson]

If column C is the amounts of the various bills.
In B4, =MAX(0,B3-SUM(C:C))

In B9 =B8-(SUM(C:C)-(B3-B4))