Page 356 - Excel 2013 All-in-One For Dummies
P. 356
338 Circular References
Figure 1-17:
Income statement with a resolvable circular reference.
To resolve the circular reference in cell B15 and calculate the bonuses based on net earnings in B21, you simply need to select the Enable Iterative Calculation check box in the Calculation Options section of the Formulas tab in the Excel Options dialog box (File➪Options➪Formulas or Alt+FTF). However, if manual recalculation is selected, you must click the Calculate Now (F9) command button on the Formulas tab of the Ribbon or press F9 or Ctrl+= as well.
