Forum Discussion
Circular Reference
I have a spreadsheet I am building that has a cell ( we'll call B20) that is a percentage of the sum of B1:B15. The problem is that some of the values in B1:B15 need to be calculated as a percentage ...
That causes a circular reference, so select File > Options > Formulas and tick the check box 'Enable iterative calculation'.