|
How many
times does Excel repeat a calculation? Once? Twice? Say you make a
mistake, a circular reference that adds itself to itself, then the
computer would calculate the same formula forever. You can set the
iterative calculation in the Backstage.
Try it: Set iterative Calculation Options Open any sample
spreadsheet you created in the previous lessons. Go to
File ->Options->Formulas. There is a
check mark for Enable iterative calculation. The default settings
are: Maximum
Iterations: 100 Maximum
Change: 0.001 The
Maximum Change is the smallest change that you will accept between
calculations. The smaller the number, the more accurate the result
and the more time Excel needs to recalculate a worksheet
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.2. Manipulate formula options: Set
Iterative Calculation Options
File ->Options-> Formulas
|
|
| |
