How To Allow Iterative Calculations In Excel

Sep 25, 2019 To enable and control iterative calculation in Excel Office 365 in windows version as I mention above please, open Excel file click File Options Formulas, and select the Enable iterative calculationcheck box under the Calculation options. You can follow my below screenshot steps. Let us know if you need additional assistance. This method has worked for my professor and colleagues, infact I have an entire model from a colleague that when I open and enable editing all data connected to cells with similar If statements are plagued with a #NAME error, which is also happening whenever I try to make use of these formulas in my model.

Definition of Iteration:-
It is the repeated calculation of a worksheet until a specific numeric condition is met. Excel cannot automatically calculate a formula that refers to the cell — either directly or indirectly — that contains the formula. This is called a circular reference. If a formula refers back to one of its cells, you must determine how many times the formula should recalculate. Circular references can iterate indefinitely. However, you can control the maximum number of iterations and the amount of acceptable change.
The Enable Iterative calculations option allows us to do so.

How to allow iterative calculations in excel

Go to File > Options.
Excel Options dialog box will appear. Click Formula and tick the checkbox enable iterative calculations and click OK.
Now perform the Iterative option in Excel.
Use the formula in A1 cell

Use the formula in A2 cell

=1+A1

As you can see the blue arrow pointing towards each other shows that the values of both cells depend on each other’s value.

How To Allow Iterative Calculations In Excel

Hope you will be performing more and more functions now. Please state that your query down in the comment box. We will help you.

Allow Iteration Calculations In Excel