What is iteration and how to use it; please advise

regards
Khalil

'Iteration' is simply repeating something.

Typically, in the computing world, it refers to some form of a looping
process within code. Worksheet functions have few iterative capabilities,
although it could be argued that various functions must do repetitive work
"behind the scenes" to achieve the single output that they provide. For
example, the SUMIF() function iteratively tests numerous cells for a
condition and adds values based on the results of those tests.

Within code, iterative actions usually involve loops such as For...Next
While...Wend Do...Loop and similar commands.

"Khalil" wrote:

What is iteration and how to use it; please advise

regards
Khalil

Iteration is the process of obtaining a solution through the use of sucessive
improving estimates of the solution.

It is used if a numerical solution is required and ther is no easy closed
form to use.

http://en.wikipedia.org/wiki/Iterative_method
--
Gary''s Student - gsnu200857


"Khalil" wrote:

What is iteration and how to use it; please advise

regards
Khalil

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

Hi Shane Devenshire

many many thanks for you professional time and advice

"Shane Devenshire" wrote:

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