Microsoft KB Archive/20787

Multiplan: Using the Itercnt and Delta Functions PSS ID Number: Q20787 Article last modified on 01-16-1991 PSS database name: D_MPlan

1.x 2.x 3.x 4.00 4.01 4.20

MS-DOS

Summary:

When structuring a worksheet for iteration, the Delta function should be placed before and after the cells that perform the iteration. This process “blocks” the iteration cells away from regular calculations, allowing the Delta function to measure the maximum change of the cells between two Delta functions.

Because the Itercnt function increments by 1 with each iteration pass, the Itercnt function should be placed in a cell outside the region defined by the two Delta functions described in the previous paragraph. If placed within the region, the Delta function will return a maximum value of 1 after each iteration pass; hence, the iteration will never terminate by measuring convergence.

Copyright Microsoft Corporation 1991.