Microsoft KB Archive/20786

The Function If(true,&quot;&quot;,Delta) Hides #N/A! PSS ID Number: Q20786 Article last modified on 07-24-1988 PSS database name: D_MPlan

2.x 3.00 3.01 3.02 3.04

MS-DOS

Summary: On its own, the Delta function returns the #N/A! error during the first two iteration passes. To hide this error, place the following formula in the cell at the top or beginning of the iteration region:

IF(true,&quot;&quot;,delta)

When processed, both the true and false clauses are evaluated, but only the true clause is displayed and the cell remains blank. The formula in the cell at the bottom or end of the iteration region must return a numeric value for the completion test to function properly. You can, however, enter the following formula:

if(isna(delta),&quot;&quot;, )

Note that doing this may require some modification of the formula in the completion test cell.

Copyright Microsoft Corporation 1988.