# Circular Logic Difficulties

1. ## 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!

2. ## Re: Circular Logic Difficulties

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

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

3. ## Re: Circular Logic Difficulties

Ahhh that worked!! Thanks!!

4. ## Re: Circular Logic Difficulties

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1