Microsoft KB Archive/63903

Multiplan: How to Avoid Displaying Zero Results in a Formula PSS ID Number: Q63903 Article last modified on 08-22-1990 PSS database name: D_MPlan

1.04 1.06 1.10 1.20 2.00 2.01 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

The IF statement can be used around a formula to suppress zeros. For example, the formula SUM(R11) can be used to sum row 11. If the result is zero, a blank cell can be substituted for the zero result by using the following formula:

IF(SUM(R11)=0,&quot;&quot;,SUM(R11)).

Notice that the formula is repeated twice. SUM(R11)=0 is the condition and tests the formula to see if it is equal to zero. The double quotation marks indicate that a blank cell will be shown if the condition is true. SUM(R2) will be printed if the condition is false, that is, the formula gives a zero result.

Note that any formula can be used in place of SUM(R11).

Copyright Microsoft Corporation 1990.