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