Circular Logic Difficulties

Hey guys, this is a strange one that I am having a bit of difficulty with.
There is some circular logic that I just can't seem to get around.
Maybe someone has done something similar before?

SEE ATTACHMENT


Some background:

I have a column D that shows accumulative profit month after month.
Column D is a sum of Column E, which shows the monthly revenue.

Every time Column D reaches a multiple of $1000, a $1000 (times the multiple) investment is made.
This $1000 (times the multiple) is subtracted from Column D.
This investment causes the monthly revenue in column E to increase by $150 (times the multiple).

For example, if in month 11 I have $2100 total profit, that would mean that month 12 would subtract $2000 for investments, but add $300 to the monthly revenue.


It's a relatively easy concept to understand, but all of the relationships in excel are codependent.
Any ideas on how I could to this in an automatic way without VBA?


Thanks!

Is this what you want? (In G4 and drag down...)

=IF(D3>=1000,INT(D3/1000)*-1000,0)

Ahhh that worked!! Thanks!!