Microsoft KB Archive/43162

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

MACINTOSH

=
=========================================================

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 :

=IF(B21<1,NA,NA)

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.