Circular References

 
 

To allow our super-snazzy formulas to work (otherwise known as a circular reference),
you will need to switch on your ITERATIVE CALCULATION, as shown below.

It's super easy!


In the top left-hand corner, hover over Excel & click on Preferences.

Under Formulas & Lists click on Calculation.

Select Use Iterative Calculation (a tick should appear) & you are good to go.

Screen Shot 2018-05-01 at 18.13.17.png

BAck to the FAQ's