Microsoft KB Archive/58257

Suppressing Zeros in Multiplan PSS ID Number: Q58257 Article last modified on 03-28-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

It is possible to suppress zeros in Multiplan by using an IF statement. After choosing the Value mode, enter the following in one cell:

1. Enter “IF(” (without the quotation marks).
2. Enter the formula to be evaluated.
3. Enter “=0” (without quotation marks) immediately after the formula.
4. Enter a comma, two quotation marks (that is, ""), and another comma.
5. Again, enter the formula to be evaluated.
6. Enter “)” (without the quotation marks) and press the ENTER key.

Multiplan tests the formula to see if it equals zero. If it is zero, nothing is entered in the cell. Otherwise, the formula is evaluated and the answer is placed in the cell.

For example, if the formula is

R1C3*R4C5

the expression is entered as follows:

IF(R1C3R4C5=0,"",R1C3R4C5)

Copyright Microsoft Corporation 1990.