Forum Discussion

Mike Reed's avatar
Mike Reed
Copper Contributor
Feb 09, 2018

Circular Reference avoidance?

I have a large spreadsheet workbook for financial services tracking income & expenses.

We remove shortfalls from a savings account and then need to update the savings account balance.  Of course this creates a circular reference problem.

 

Partial worksheet attached. Column B negatives are covered by column K, but then we need to reduce column L by the same amount.

 

Is there some sort of workaround for this?

No RepliesBe the first to reply