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.