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
==========================================================
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 :
=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.