Assuming data as posted in cols A to E, from row2 down
In E2: =IF(D20,B2-D2,B2)
In E3: =IF(D30,E2-D3,SUM(E2,B3))
Copy E3 down. This seems to give the results that you posted.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
Here is an example of the cells:

A B
C D E
Due Date Total Current due Date Received Current amount paid Current
Amount Behind

6/17/2005 $200.00
$0.00 $200
7/1/2005 $200.00
$0.00 $400
7/15/2005 $200.00
$0.00 $600
7/29/2005 $200.00 8/5/2005
$200.00 $400

If D shows no Payment amount or $0.00 then Add amount from B $200
Once D shows an amount Subtract that amount from previous E amount
This will continue down E until E finally = 0.00 which would be
current. Then it continues, if D shows 0 then it adds amount from B
to E