Microsoft KB Archive/20788

Multiplan: Using the ITERCNT and DELTA Functions PSS ID Number: Q20788 Article last modified on 02-01-1991 PSS database name: D_MPlan

1.x 2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

The completion test can test for two conditions: the value returned by DELTA is less than a specified amount, or a fixed number of iterations have been performed.

More Information:

For example, assuming the area of iteration has been blocked by two DELTA functions, the completion test can be entered as the following:

OR(DeltaEnd<=aValue,Itercnt>=MaxIterations)

DeltaEnd references the cell containing the DELTA function at the “bottom” or end of the iteration region, and the aliases “aValue” and “MaxIterations” are either numeric values or refer to cells containing numeric values. These numeric values may be either hard values or formulas.

Copyright Microsoft Corporation 1991.