Microsoft KB Archive/43162

From BetaArchive Wiki

Mac Works: Returning Blank Cell in =IF Statement Not Supported

PSS ID Number: Q43162 Article last modified on 10-22-1998

1.1 2.0 3.0 4.0


The information in this article applies to:
- Microsoft Works for the Macintosh, versions 1.1, 2.0, 3.0, and 4.0

Because the Works Spreadsheet module will not support text string values in formulas, Works will not return a blank cell in an =IF statement.

However, Works will return the value “N/A.” To do this, type “NA()” (without the quotation marks) in the value-if-true or the value-if-false function. For example, the following formula will return N/A :


KBCategory: kbusage KBSubcategory: macworkskb

Additional reference words: function 1.10 2.00 3.00 4.00 empty gives mwksss nothing zero ====================================================================== Version : 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.