Works: Using an IF Command with a Blank Field
PSS ID Number: Q62341 Article last modified on 06-12-1996
2.00
MS-DOS
SUMMARY
To use an IF statement to compare a blank field in a spreadsheet, a zero is used as the comparison value. For example, the statement
If cell A1 is blank then do … else do …
may be translated into the following equation:
IF(A1=0,ActionIfTrue,ActionIfFalse)
KBCategory: kbother KBSubcategory: dworkskb Additional reference words:
============================================================================= Copyright Microsoft Corporation 1996.