All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hi all,
I've written up an intentional circular reference as I need two cells to be identical when a certain criteria is met. These cells are also editable by other uses, both cells are set to 0 by default, it is only when one cell is changed, the other one must change.
Is there a way to re-write this code to remove the circular reference, or even turn off the warning that appears? (Enabling iterative calculations will not work as many different users are using this sheet across multiple computers). Thanks in advance!
Formula 1: =IF('Fact Finder'!O1="c",IF('Summary (Bulk)'!T2>0,'Summary (Bulk)'!T2,0),0)
Formula 2: =IF('Fact Finder'!O1="c",IF('Summary (Parcel)'!T2>0,'Summary (Parcel)'!T2,0),0)
I've written up an intentional circular reference as I need two cells to be identical when a certain criteria is met. These cells are also editable by other uses, both cells are set to 0 by default, it is only when one cell is changed, the other one must change.
Is there a way to re-write this code to remove the circular reference, or even turn off the warning that appears? (Enabling iterative calculations will not work as many different users are using this sheet across multiple computers). Thanks in advance!
Formula 1: =IF('Fact Finder'!O1="c",IF('Summary (Bulk)'!T2>0,'Summary (Bulk)'!T2,0),0)
Formula 2: =IF('Fact Finder'!O1="c",IF('Summary (Parcel)'!T2>0,'Summary (Parcel)'!T2,0),0)
