A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Iteration



 
 
Thread Tools Display Modes
  #1  
Old June 19th, 2009, 04:28 PM posted to microsoft.public.excel.worksheet.functions
khalil
external usenet poster
 
Posts: 7
Default Iteration

What is iteration and how to use it; please advise

regards
Khalil
  #2  
Old June 19th, 2009, 04:37 PM posted to microsoft.public.excel.worksheet.functions
JLatham
external usenet poster
 
Posts: 1,896
Default 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  
Old June 19th, 2009, 04:40 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
external usenet poster
 
Posts: 7,584
Default 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  
Old June 19th, 2009, 05:02 PM posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_3_]
external usenet poster
 
Posts: 3,333
Default 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  
Old June 19th, 2009, 08:21 PM posted to microsoft.public.excel.worksheet.functions
khalil
external usenet poster
 
Posts: 7
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.