Microsoft KB Archive/150517

= Works: Blank Cell Does Not Equal Zero or Text =

Article ID: 150517

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q150517



SUMMARY
When you compare values in a spreadsheet or database, Works treats a blank cell as a zero, but does not treat a text entry as a numeric zero. For example, the formula

=if(A1=B1,"True","False")

will return a True if cells A1 and B1 are blank or contain a zero. The formula will return a False if cells A1 and B1 contain text and either a zero or are blank.



MORE INFORMATION
When you perform other types of comparisons, greater than(>), less than (<), or not equal (<>), a text entry is treated as not equal (<>) to numeric values, zeros, or blank cells. Earlier versions of Works for Windows treated text entries as equivalent to zero values.

Additional query words: 4.00 4.00a 4.50 4.50a w_works works2000 works6 wks

Keywords: kbinfo KB150517

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.