If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Iteration
What is iteration and how to use it; please advise
regards Khalil |
#2
|
|||
|
|||
Iteration
'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 |
#3
|
|||
|
|||
Iteration
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 |
#4
|
|||
|
|||
Iteration
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 |
#5
|
|||
|
|||
Iteration
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 |
Thread Tools | |
Display Modes | |
|
|