Iterative Calculations

How many times does Excel repeat a calculation? Once? Twice? Say you make a mistake, a circular reference that adds itself to itself, then the computer would calculate the same formula forever. You can set the iterative calculation in the Backstage.


Try it: Set iterative Calculation Options

Open any sample spreadsheet you created in the previous lessons.

Go to File ->Options->Formulas.

There is a check mark for Enable iterative calculation. The default settings are:

Maximum Iterations: 100

Maximum Change: 0.001


The Maximum Change is the smallest change that you will accept between calculations. The smaller the number, the more accurate the result and the more time Excel needs to recalculate a worksheet

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.2. Manipulate formula options: Set Iterative Calculation Options

File ->Options-> Formulas