Microsoft KB Archive/62341

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.