Microsoft KB Archive/62341: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q62341 to Microsoft KB Archive/62341 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:26, 12 August 2020
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.