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!
Bookmarks