The Iteration option is useful for performing calculations on a cell containing circular reference repeatedly. If a cell refers to itself in a formula then it is said to have a circular reference. For example , the cell B3 containing the below formula is said to have a circular reference:
=IF(B3 < 1000, B3 + 50, B3 + 100) The maximum value 100 in the Options dialog box means that the calculation "B3 + 50" or "B3 + 100" is performed 100 times every time the worksheet is calculated. Pressing the F9 function key initiates calculations on the worksheet. The above formula result would be 9000. Press F9 and you would see the result in B3 change to 19000. If you change the value from 100 (default) to 1 then the calculation would be performed only once. You would see the initial value of the formula as 50 followed by 100, 150, 200 and so on. Hope this makes sense! On 4/11/13, Mukesh <[email protected]> wrote: > Dear friends, > There is a maximum iteration option in excel option- formula – maximum > iteration 100. I want to know the use of this option which is set to hundred > by default. If I will change it to 1 what will be the effect of it in > spreadsheet . > Thanking you in anticipation. > Regards > > Mukesh Baviskar > Mobile: 9403161157 > Skype id: mukeshbaviskar > Blog: > http://mukeshbaviskar.blogspot.com > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
