Iteration function in Microsoft Excel

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.

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

=1+A2

Use the formula in A2 cell

=1+A1

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

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

Users are saying about us...

  1. Solomon Abdetta

    It is so vivid and profusely nurturing my growing knowledge and skill in understanding and utilizing Excel that would definitely boost my contribution to the organization i am currently working in even though i am staying there with full refugee status. Thank you for innovating such free access to such great work which could hardly be possible for people like me.....

  2. Hi, I would like to iterate a column vector for 10 times, for example:
    1.31
    1.26
    1.19
    1.33
    1.32
    1.47
    1.31
    1.21
    Could you help me on this calculation? Thanks in advance

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube