Hi,

And if you are asking about the Interation option in the Tools, Options,
Calculation tab of Excel - this allows you to control how many times Excel
recalculates while trying to reach a final answer. The option also lets you
indicate how much change there is between each calculation before it stops
recalculating. In most situations this area is of no concern to Excel users.

Iteration: Limits iteration for goal seeking or for resolving circular
references. Unless you specify otherwise, Excel stops after 100 iterations or
when all values change by less than 0.001. You can limit iteration by
changing the number in the Maximum iterations box, the Maximum change box, or
both boxes.

Maximum iterations: Type the numbers in the Maximum iterations and Maximum
change boxes to change the maximum number of iterations used and the maximum
amount of change below which iteration stops.

Maximum change: Type the numbers in the Maximum iterations and Maximum
change boxes to change the maximum number of iterations used and the maximum
amount of change below which iteration stops.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Khalil" wrote:

What is iteration and how to use it; please advise

regards
Khalil