Works: Blank Cell Does Not Equal Zero or Text (150517)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works 2000
- Microsoft Works 4.5
- Microsoft Works for Windows 95, version 4.0
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.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbinfo KB150517 |
|---|
|