#1   Report Post  
Posted to microsoft.public.excel.misc
M. Homayon
 
Posts: n/a
Default Iteration

Hello,
Would someone instruct me please about the "Iteration" in the Options of
Tools menu. Please tell me the complete steps to use Iteration option. ...
Thanks.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Jay
 
Posts: n/a
Default Iteration

Would someone instruct me please about the "Iteration" in the Options
of Tools menu. Please tell me the complete steps to use Iteration
option. ... Thanks.


Iteration is a way to solve a problem approximately, by repeatedly stepping
closer and closer to the answer. Excel uses iteration when you invoke:
Tools Goal Seek

When iteration works, you can get as close as desired (within Excel's
precision limitations) by taking enough steps. Be aware, though, that
iteration isn't guaranteed to converge to an answer. It depends on the
problem, on the type of iteration method, and on the initial guess. Excel
gives a warning if Goal Seek doesn't converge.

Usually, iteration continues until either (a) the software takes a maximum
number of steps, or (b) the difference between successive steps is small.

If you want to control the "maximum number of steps" in (a), or the
"difference between successive steps" in (b), you can use the "Iteration"
section of the "Options."

For most problems, the default values that Excel provides are good enough,
and there's no need to change the Iteration option. If you have a problem
where the default values don't work, please provide details of what goes
wrong.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterative process, bioyyy Excel Discussion (Misc queries) 5 December 1st 05 02:07 AM
Using iteration to solve a two-parameter equation Jason Excel Discussion (Misc queries) 4 October 13th 05 08:35 PM
How do I resolve complex iteration problems in Excel? William Sporborg Excel Discussion (Misc queries) 7 September 21st 05 03:06 PM
Use of iteration function Eddy VG Excel Worksheet Functions 2 August 27th 05 12:15 AM
Pivot table iteration Kymezo Excel Worksheet Functions 0 March 1st 05 07:04 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"